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

ORA-06553: PLS-306: wrong number or types of arguments in call to ‘OGC_Y’ while exporting table

Recently i had faced "ORA-06553: PLS-306:" error while taking an export using expdp for table using "query" parameter. $ expdp directory=TEST_DPUMP_DIR dumpfile=test_url.dmp logfile=test_url.log tables=anand.test_delete_objects query=\"WHERE processed_flag = 'Y'\" Export: Release 11.2.0.3.0 - Production on Tue May 29 00:24:25 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Username: system Password: Connected to: … Continue reading ORA-06553: PLS-306: wrong number or types of arguments in call to ‘OGC_Y’ while exporting table

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

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

EXPDP – ORA-39166: Object XXX was not found.

SQL> create table scott."test" as select * from scott.dept; Table created. SQL> select * from scott.TEST; select * from scott.TEST * ERROR at line 1: ORA-00942: table or view does not exist SQL> select * from scott.test; select * from scott.test * ERROR at line 1: ORA-00942: table or view does not exist SQL> select … Continue reading EXPDP – ORA-39166: Object XXX was not found.