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