Database Utilities (MOSC)

MOSC Banner

Error in exp

edited Oct 8, 2009 12:56AM in Database Utilities (MOSC) 4 commentsAnswered ✓
 Running a full=y export in 10.2 using old exp method (not data pump) as a user with dba role granted.

Getting following errors at the start but rest of the exp runs fine.

. about to export SYSTEM's tables via Direct Path ...
Table DEF$_AQCALL will be exported in conventional path.
. . exporting table                    DEF$_AQCALL
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 18:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' 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 126

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center