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

Mining DDL from LogMiner

One may sometimes need to find the ddl which ran on the database at some certain period of time.If auditing is enabled for the you can get the details using various *_audit_* views. In case, its not and the database is in archivelog mode you can try using logminer.Here is an example for it -- … Continue reading Mining DDL from LogMiner