Anônimo.
souzaNo arquivo de log do export dá o seguinte erro abaixo. Tenho outra dúvida: Para que server o “direct=y” ?
exp usuario/senha@base full=y direct=y file=d:backupOracleCONSULTconsult.dmp log=d:backupOracleconsult.log
. exporting system procedural objects and actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body “SYS.LT_EXPORT_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.system_info_exp
EXP-00008: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at “SYS.DBMS_RMGR_GROUP_EXPORT”, line 130
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_RMGR_GROUP_EXPORT.grant_exp for object 3844
EXP-00008: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at “SYS.DBMS_RMGR_GROUP_EXPORT”, line 130
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_RMGR_GROUP_EXPORT.grant_exp for object 3845
EXP-00008: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at “SYS.DBMS_RMGR_GROUP_EXPORT”, line 130
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling SYS.DBMS_RMGR_GROUP_EXPORT.grant_exp for object 3846
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body “SYS.LT_EXPORT_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.system_info_exp
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body “SYS.LT_EXPORT_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier ‘LBACSYS.LBAC_UTL’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling LBACSYS.LBAC_UTL.schema_info_exp
Anônimo
Quanto a opção direct=y:
Indica se uma exportação direta deve ser executada. Uma exportação direta desvia do cache de buffer durante a exportação gerando ganhos de desempenho significativos para o processo de exportação. O default é N.