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…
Oracle Apps 11i is divided into : Database Tier ( Database & DB Listener ) and Application Tier ( WebServer,…
Oracle Database philosophy is Data Recover-ability. This is the reason if you have a huge table with more than 100…
**************** Cloning of the Oracle Database ******************** On production 1) Make sure controlfile autobackup is on and take the incremental…
A small shell script to check instance status of oracle database. $vi instanceup.sh #!/bin/sh SERVICE=’ora_pmon_orcl’ #replace ‘orcl’ with your sid…
One of the requirements in modern organizations where data integrity and security is of utmost importance, is the use of…