Showing posts with label Oracle 11g. Show all posts
Showing posts with label Oracle 11g. Show all posts
Saturday, July 27, 2013

ORA-00439 feature not enabled Deferred Segment Creation 11g enterprise to standard edition downgrade

›
1293326.1 http://lifeandoracle.blogspot.in/2012/07/ora-00439-feature-not-enabled-deferred.html http://ocpdba.wordpress.com/2009/10/09/d...

Oracle 11g2 does NOT export empty tables when using exp.exe

›
http://tsells.wordpress.com/2011/02/10/oracle-11g2-does-not-export-empty-tables-when-using-exp-exe/ Out of habit I have been using the old...
Tuesday, November 6, 2012

11g File Watcher

›
http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse005.htm http://www.oracle-base.com/articles/11g/scheduler-enhancements-11gr2...
Monday, November 5, 2012

11g Migration using RMAN

›
The steps for 10g database: 1- Run the utlu112i.sql Pre-upgrade script. You can find this script under @$ORACLE_HOME/rdbms/admin/. It mus...
Tuesday, September 25, 2012

expdp procedure in 11g

›
 1) create directory export_auto as 'd:\expdp1213';  create user dba_export_user identified by test123; grant connect, create d...
Friday, September 14, 2012

11g Active Data Guard - enabling Real-Time Query

›
Active Data Guard is a good new feature in 11g (although requires a license) which enables us to query the Standby database while redo log...
Wednesday, August 29, 2012

Oracle 11g Advanced Compression

›
You can implement advanced compression option into your databases having more update, insert operation tables to manage high growing amoun...
Wednesday, August 1, 2012

Purging trace and dump files with 11g ADRCI

›
Purging trace and dump files with 11g ADRCI In previous versions of Oracle prior to 11g, we had to use our own housekeeping scripts t...

Trace Dump File Housekeeping in 11g Adrci

›
Automatic Diagnostic Repository Command Interface Starting with 11gR1, we have a new way to deal with Oracle Errors & Tracefiles: Th...