How to exclude table from EXPDP Backup

To exclude table from EXPDP Backup. Let's take a case, you have 100 tables in your schema and you want to export only 99 of them excep...

TNS-12549: TNS-00519 Linux Error: 28: No space left on device

Symptoms: Issue command: lsnrctl start listener_dbsrv2 LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 15-FEB-2008 08:58:03 Copyr...

How to change db_recovery_file_dest and db_recovery_file_dest_size parameter

Applies to:  Oracle Std & Enterprise Edition - Version: 11.1.1.1.0 and later   [Release: 11gR1 and later ]Information in this doc...

Database Background Processes

Background Processes Maintains and enforces relationships between physical and memory structures There are two types of database processe...

Statistics space used by SM/OPTSTAT in the SYSAUX tablespace is not reclaimed after purging

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.2 This problem can occur on any platform. Oracle Server Ent...

ORA-600 [kwqbdrcp101] after Drop or Recreate of Propagation

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later] Information in this documen...

How to Stop EXPDP or IMPDP Job

Applies To: Oracle 10.2.0.1 onwards Command: Expdp and Impdp job is running suddenly need to stop this job. Use following job: 1.       ...

How to rebuild an Index ?

Command: Sql> alter index [index_name] rebuild online; Before that check your tablespace should have enough free space. In rebuilding...