Do a “create table” as command without selecting any rows create table abc_new as select * from abc where 1=0;
Category Database
1. Install Latest OPatch clients from support.oracle.com – As Grid User — unzip p6880880_112000_SOLARIS64.zip -d $ORACLE_HOME ##Replace All – As…
Original Article on http://www.orafaq.com/node/2756 by Micheal Rajendran Introduction Oracle has leap forwarded the middleware technologies especially the database technology into the cloud.…
Primary is a 2 node-rac cluster with instances swx1 and swx2 running on ASM. A service called swxscan is created…
Many a times to save cost in building a DR solution for a certain application; you have to create a…
Problem —— Error on starting ASM from SQLPLUS or ASMCMD SQL> startup; ORA-01078: failure in processing system parameters ORA-29701: unable…
To Configure RAC 11gR2 on AIX 6.1 using ASM. You need to prepare the raw devices like below. The general…
bash-3.2$ impdp system/***** directory=import_dir nologfile=y dumpfile=exp_swx_20092012.dmp full=y ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open…
The various security mandates these days required a lot of auditing on the database. Though there are a host of…
Occasionally you need to create a quick one node RAC setup for testing and one of the requirements is a…
SQL> conn / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. SQL> drop database; drop…
While trying to troubleshoot an application connectivity issue today along with a developer I faced an interesting situation. We had…
Working on creating a muti-master replication for a production system. Each database needs to be active and replicate changes back…
Oracle GoldenGate will now be more closely coupled with Oracle database. And it is by far the best heterogenous replication…
GoldenGate is touted by Oracle as its future for data replication. It will slowly phase out Oracle Streams and will…
// *Cause: The archiver process received an error while trying to archive // a redo log. If the problem is…
When a large number of records neds to be deleted from a table. If you do a normal delete it…
Recovery interrupted! Recovered data files to a consistent state at change 13507372 Fri May 11 20:11:09 2012 Errors in file…
Guaranteed Restore Points are a life-saver when it comes to Application changes.It can ensure that you can rewind the database…
I had a block corruption of my primary database, though we had a standby build we wanted to recover the…
Flashback Technology provided by Oracle is one of the most useful in a production environment. It is a life saver.…
This error occurs when you have a public synonym defined and the object referencing or owning the synonym has been…
CAUTION !!!! DO NOT DO THIS ON YOUR PRIMARY. IF YOU DO THEN YOU WOULD REQUIRE MEDIA RECOVERY ON THE…
SELECT /*+ RULE */ GRANTEE FROM SYS.DBA_ROLE_PRIVS A WHERE GRANTED_ROLE=’DBA’ AND EXISTS (SELECT NULL FROM ALL_USERS WHERE USERNAME =A.GRANTEE);