Thursday, February 28, 2008

FIX EXP-00008: ORACLE error 604 encountered while exporting full database

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

0 comments: