My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.