Oracle Tips and Techniques

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 »

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 »

A very useful note on how to create a blog. This article will describe briefly the major components of a blog and where to source them

Filed under: Others by admin
No Comments »

Alter database command is used to add loggfile or add logfile member in Oracle. This post gives the commands used to create a redo log group and adding members to this group.

Filed under: Oracle DBA Scripts by admin
No Comments »