error when exporting

Printable View

05-10-2002, 04:31 PM
tang

I tried to export all the objects that own by myself to a .dmp file. I got this error message:
EXP-00008: ORACLE error 6550 encountered
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_info_exp
. exporting statistics
Export terminated successfully with warnings. I am not sure what the problem is. Could you help? Thanks in advance!
05-10-2002, 04:44 PM
Mr.Hanky

Can you post the parfile or parameters you are using as well, that would help.

MH
05-11-2002, 04:50 AM
sjadhavdba

which version u r using. 9i????
05-11-2002, 09:48 PM
sanjay92

Connect as sys and grant this privileges before running the export:
GRANT EXECUTE ON sys.lt_export_pkg TO exp_full_database;

OR

GRANT EXECUTE ON sys.lt_export_pkg TO PUBLIC;

Sanjay

Quote:

Originally posted by tang
I tried to export all the objects that own by myself to a .dmp file. I got this error message:
EXP-00008: ORACLE error 6550 encountered
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_info_exp
. exporting statistics
Export terminated successfully with warnings. I am not sure what the problem is. Could you help? Thanks in advance!
05-13-2002, 11:23 AM
tang

Thanks a lot to all of you. Sanjay's suggestion is right. It works now. By the way, I am using version9i.