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

EXPDP – Smarter in 11gR2

I feel Oracle has made EXPDP utility more smarter by its releases.The below command fails on 10gR2 as "owner" is an unknown parameter for expdp. Correct syntax would be using SCHEMAS parameter in expdp. [oracle@localhost Desktop]$ expdp directory=DATA_PUMP_DIR dumpfile=full_feb16_scott.dmp logfile=full_feb16.log owner=scott LRM-00101: unknown parameter name 'owner' What happens when we try the same on 11gR2 … Continue reading EXPDP – Smarter in 11gR2

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