EXPDP Results In ORA-39127, ORA-6550, PLS-302, ORA-6510 Referencing EXPORT_RULE_SET (Doc ID 1535537.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Trying to use EXPDP results in:

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39127: unexpected error from call to BEGIN :1 :=SYS.DBMS_EXPORT_EXTENSION.POST_TABLES(:2,:3); END; USING ASO, ASO_ORDER_FEEDBACK_T 
ORA-06550: line 1, column 42:
PLS-00302: component 'EXPORT_RULE_SET' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 148
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_ME
ORA-39127: unexpected error from call to BEGIN :1 :=SYS.DBMS_EXPORT_EXTENSION.POST_TABLES(:2,:3); END; USING CSP, CSP_SEC_INVENTORIES 
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 148
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5706

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms