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
Keeping consistent..... August 16, 2012 +0 expdp consistent=y consistent flashback_time exp export expdp consistent=y consistent flashback_time exp export