srvctl modify instance command syntax and example

The srvctl modify instance command is used to modify an instance configuration in the OCR (Oracle cluster registry). Learn here the syntax and example of how to use this command

Oracle database startup stages and commands

The three Oracle database startup stages executed while opening an Oracle database is explained here. Each stage is explained in separate section with commands. The commands are generic and should work for any version of Oracle execpt sqlplus / as sysdba which will not work in Oracle 8.

Error:ORA-30926: unable to get a stable set of rows in the source tables

See the explanation and solution of Oracle MERGE UPDATE error Error:ORA-30926: unable to get a stable set of rows in the source tables. This article will show you why this error happens and then you will know how to prevent it.

Clone Oracle database – cloning Tutorial

How to clone oracle database – this is a step by step guide to clone Oracle database to replace a corrupt database. The steps are machine independent so this oracle database cloning steps should work in Windows, Unix or VMS etc. For non-unix environment the path of the oracle datafiles, logfiles and control file should be changed accordingly.

Oracle 11G’s Strong Verifier and Case Sensitive Password

by: Paul Fleming
As an Oracle DBA, you probably have heard a lot about the new security features in Oracle 11G such as database vault, audit vault, strong verifier, enhanced ASO, etc. But with a busy schedule, how do you find the time to study all the topics in depth? Are all of them going to [...]

Oracle Global Temporary Table Example

Example and usage of Oracle Global Temporary Table.

Oracle tablespace concept and increasing size of Oracle tablespace

This post explains the Oracle tablespace concept and provides all the commands that you will need to administer Oracle tablespaces.

How to Enable or Disable a constraint an Oracle constraint?

Sometime you may want to ENABLE or DISABLE a constraint for some reason. Learn here the way to do it.

Oracle Alter Table Commands

Learn with example: ALTER TABLE is a very powerful and versatile command in Oracle. It is a DDL (data definition language) command as it changes the definition of a table or it’s columns behaviour.



Similar Posts