—– Procedure to import table from production system to test system —— 1. Copy the backup(dump) of schema onto /backup_restor_only…
####PSU patching, interim patches ##### Sometimes before moving to a new 10.2.0.* version there are CPU patches released on a…
How to backup the Oracle Control File? There are two approaches: you either generate a binary image of the Control…
Whenever you are trying to backup Archivelogs from RMAN you might get the following error. Starting backup at 25-FEB-10 current…
I’m now a certified expert in Oracle. Just cleared the 1z0-048 exam for Oracle RAC 10g Cluster. The exam tests…
The size of the database is the total size of the datafiles that make up the tablespaces of the database.…
SQL> select * from v$flashback_database_log; SQL> show parameter db_file SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=2g; System altered. SQL> alter system set…
1. Turn on block checking REASON: The aim is to detect, very early the presence of corrupt blocks in the…
Copy Table to a new table with some condition ______________________________________________ SQL> CREATE TABLE newTable AS (SELECT * FROM emp WHERE…