Delete Duplicate Rows
Finding and deleteing the duplicate rows of a table in Oracle Database. DELETE FROM OWNER.TABLEx z WHERE z.ROWID IN (SELECT …
Category Archives: Oracle Database
MRP0: Detected orphaned datafiles!
Datafile 1 (ckpscn 139334570249) is orphaned on incarnation#=2 MRP0: Detected orphaned datafiles! Recovery will possibly be retried after flashback… Errors …
File # added to control file as UNNAMED
Errors in file …/trace/RAPOR_pr00_2801804.trc: ORA-01119: error in creating database file ‘/data/datafile_1.dbf’ ORA-27054: NFS file system where the file is created …
Excluding Table Partitions – expdp EXCLUDE=TABLE_DATA
Oracle Datapump – Using expdp utility excluding table & table partitions in a par file can be managed with the …
Physical Dataguard Configuration
Some fast and easy configuration scripts for Physical Dataguard installation… PRIMARY Site ALTER SYSTEM SET db_unique_name = DATABASE; ALTER SYSTEM …
Range Partitioning with DBMS_REDEFINITION Package & Compression
validate index OWNER.TABLE_INDEX; SELECT opt_cmpr_count, opt_cmpr_pctsave FROM index_stats WHERE name = ‘TABLE_INDEX’; OPT_CMPR_COUNT OPT_CMPR_PCTSAVE ————– —————- 1 10 select min(LOG_DATE), …
Optimize Oracle UNDO Parameters
I appreciate the post about the undo tunning, here is the link… http://www.akadia.com/services/ora_optimize_undo.html
Finding Optimum Compression Level & Compression PCT Save for Indexes
Simple but subtle compress implementation for indexes.. Check it out.. validate index OWNER.INDEX_NAME; SELECT opt_cmpr_count, opt_cmpr_pctsave FROM index_stats WHERE name …
Oracle 9.2.0.8 – 9i Release2 Dataguard Configuration Basics
cold copy or begin backup & end backup ->> All .log .dbf Create standby control file ALTER DATABASE CREATE STANDBY …
