if you had the below error (Error 1) while exporting full database
login as sys user and execute the following sql command at sqlplus prompt
GRANT EXECUTE ON sys.lt_export_pkg TO exp_full_database;
and if after running the above sql command and you got the an error (Error 2).
login as sys user and then execute the file
$ORACLE_HOME/rdbms/admin/owminst.plb to validated LT_EXPORT_PKG .
at sqlplus prompt
>@$ORACLE_HOME/rdbms/admin/owminst.plb
ie.
>@$D:\oracle\ora90\rdbms\admin\rdbms\admin\owminst.plb
Error 1
EXP-00008: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_i
nfo_exp
Error 2
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
Blast from the Past: I Don't Like Your Examples!
-
Originally written in 2000, I thought you might like to check this out in
2016.
I Don't Like Your Examples! 10/11/2000
I have been writing books about t...
8 years ago
0 comments:
Post a Comment