srvctl modify instance command syntax and example

Filed on:July 15, 2010

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

Filed under: Oracle Concept by admin
2 Comments »

Oracle database startup stages and commands

Filed on:June 2, 2010

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.

Filed under: Oracle Concept by admin
No Comments »

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

Filed on:April 29, 2010

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.

Filed under: Oracle Concept by admin
2 Comments »

Clone Oracle database – cloning Tutorial

Filed on:April 27, 2010

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.

Filed under: Oracle Concept by admin
No Comments »

Oracle 11G’s Strong Verifier and Case Sensitive Password

Filed on:March 17, 2010

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 [...]

Filed under: Oracle Concept by admin
No Comments »

Oracle Global Temporary Table Example

Filed on:February 10, 2010

Example and usage of Oracle Global Temporary Table.

Filed under: Oracle Concept by admin
No Comments »

Oracle tablespace concept and increasing size of Oracle tablespace

Filed on:January 8, 2010

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

Filed under: Oracle Concept by admin
No Comments »

How to Enable or Disable a constraint an Oracle constraint?

Filed on:

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

Filed under: Oracle Concept, Oracle FAQ by admin
No Comments »

Oracle Alter Table Commands

Filed on:December 14, 2009

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.

Filed under: Oracle Concept by admin
No Comments »



Similar Posts