error when exporting

[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!

[Mr.Hanky]

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

MH

[sjadhavdba]

which version u r using. 9i????

[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

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!

[tang]

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