Home > database >  Database exp whole database export, submitted to the following error, excuse me each master how to s
Database exp whole database export, submitted to the following error, excuse me each master how to s

Time:09-23

Connected to the Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options
Export the done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export the - the database...
The exporting in tablespace definitions
The exporting profiles
The exporting user definitions
The exporting roles
The exporting the resource costs
The exporting the rollback segment definitions
The exporting database links
The exporting sequence Numbers
The exporting directory aliases
The exporting context namespaces
The exporting foreign function library names
The exporting PUBLIC type synonyms
The exporting private type synonyms
The exporting object type definitions
The exporting system procedural objects and actions
. Exporting pre - schema procedural objects and actions
The exporting cluster definitions
. About to export SYSTEM 's tables via but Path...
.. exporting table DEF $_AQCALL
EXP - 00008: ORACLE error encountered 6550
ORA - 06550: line 1, column 19:
PLS - 00201: the identifier 'SYS. DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA - 06550: line 1, column 7:
PL/SQL Statement ignored
ORA - 06512: an "SYS. DBMS_SQL", line 1575
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 97
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 126
ORA - 06512: the at line 1
.. exporting table DEF $_AQERROR
EXP - 00008: ORACLE error encountered 6510
ORA - 06510: PL/SQL: unhandled user - defined exception
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 50
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 126
ORA - 06512: the at line 1
.. exporting table DEF $_CALLDEST
EXP - 00008: ORACLE error encountered 6550
ORA - 06550: line 1, column 19:
PLS - 00201: the identifier 'SYS. DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA - 06550: line 1, column 7:
PL/SQL Statement ignored
ORA - 06512: an "SYS. DBMS_SQL", line 1575
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 97
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 126
ORA - 06512: the at line 1
.. exporting table DEF $_DEFAULTDEST
EXP - 00008: ORACLE error encountered 6510
ORA - 06510: PL/SQL: unhandled user - defined exception
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 50
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 126
ORA - 06512: the at line 1
.. exporting table DEF $_DESTINATION
EXP - 00008: ORACLE error encountered 6550
ORA - 06550: line 1, column 19:
PLS - 00201: the identifier 'SYS. DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA - 06550: line 1, column 7:
PL/SQL Statement ignored
ORA - 06512: an "SYS. DBMS_SQL", line 1575
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 97
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 126
ORA - 06512: the at line 1
.. exporting table DEF $_ERROR
EXP - 00008: ORACLE error encountered 6510
ORA - 06510: PL/SQL: unhandled user - defined exception
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 50
ORA - 06512: an "SYS. DBMS_EXPORT_EXTENSION", line 126
ORA - 06512: the at line 1
Exporting table DEF $_LOB 0 rows exported
.. exporting table DEF $_ORIGIN

CodePudding user response:

Exp is too old to use expdp export right, the speed a lot, also more technical data,
  • Related