ORA-38500: Unsupported operation: Oracle XML DB not present

While trying to import using impdp got the below error Table "ANAND"."TEST" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "ANAND"."TEST":"Y2012_Q2_M06" failed to load/unload and is being skipped due to error: ORA-38500: Unsupported operation: … Continue reading ORA-38500: Unsupported operation: Oracle XML DB not present

Exporting tables from different Schemas using EXPDP – Revisited – version 11gR2

More than an year ago i had written https://aprakash.wordpress.com/2010/10/19/exporting-tables-from-different-schemas-using-expdp/ where in mentioned how to export tables from different schemas using the EXPDP in 10gR2. Using exp - "D:\>exp file= exp_test.dmp log=exp_test.log tables='scott.emp','hr.jobs' feedback=10" Using expdp D:\>expdp directory=DATA_PUMP_DIR dumpfile=expdp_test_1.dmp logfile=expdp_test_1.log schemas='scott','hr' include=TABLE:\"IN (\'EMP\', \'JOBS\')\" With the above expdp command the problem arises when tables with same … Continue reading Exporting tables from different Schemas using EXPDP – Revisited – version 11gR2

KEEP_MASTER and METRICS in EXPDP/IMDP

Recently, i came to know about "KEEP_MASTER" and "METRICS" , the undocumented parameter of EXPDP/IMPDP. METRICS provides the time it took for processing the objects and KEEP_MASTER prevents the Data Pump Master table from getting deleted after an Export/Import job completion. Lets check -- D:\scripts>expdp directory=DATA_PUMP_DIR dumpfile=abc.dmp logfile=abc.log tables=TM_CONS,FAKE_IND_TEST metrics=y Export: Release 11.2.0.2.0 - Production … Continue reading KEEP_MASTER and METRICS in EXPDP/IMDP