DBMS_DATAPUMP with remap_data April 10, 2013 +0 remap_data dbms_datapump plsql datapump expdp impdp oracle remap_data dbms_datapump plsql datapump expdp impdp oracle
Showing object growth over a month from AWR March 25, 2013 +0 awr space growth table object awr space growth table object
sqlldr multi table insert using external table March 25, 2013 +0 sqlldr multi table insert sequence position sqlldr multi table insert sequence position
Add primary key in parallel December 12, 2012 +0 add primary key parallel local constraint add primary key parallel local constraint
Simple use of lag function to show script runtimes August 31, 2012 +0 lag analytic function simple lag analytic function simple
querying datapump file header August 29, 2012 +0 impdp expdp datapump query file header contents impdp expdp datapump query file header contents
transportable tablespace with rman - no read only needed! August 24, 2012 +0 rman transport tablespace read only datapump rman transport tablespace read only datapump
expdp seemed to create inconsistent export even with flashback set (or did it.....) August 23, 2012 +0 expdp flashback inconsistent datapump expdp flashback inconsistent datapump
Datapump out application users oracle account August 23, 2012 +0 expdp users only datapump include schema expdp users only datapump include schema
Strangest performance problem ever.... August 16, 2012 +0 performance different client NLS_LANG sqlplus stored procedure explain plan language performance different client NLS_LANG sqlplus stored procedure explain plan language
RAC - force connection to one instance using tnsnames August 16, 2012 +0 RAC tnsnames force connect instance INSTANCE_NAME SERVICE_NAME load_balance failover RAC tnsnames force connect instance INSTANCE_NAME SERVICE_NAME load_balance failover
Moving to Advanced compression August 16, 2012 +0 advanced compression datapump expdp impdp transform segment_attributes advanced compression datapump expdp impdp transform segment_attributes