export in 9i :error [message #69636] |
Mon, 11 February 2002 19:57 |
manjunath raju
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
hi,
when export schema on 9i database , i get this error
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
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.
reply to this
|
|
|
Re: export in 9i :error [message #69704 is a reply to message #69636] |
Thu, 21 February 2002 11:26 |
Jason
Messages: 32 Registered: February 1999
|
Member |
|
|
I think I had this problem, too, when I first upgraded to 9i. Try (as sys)...
grant execute on sys.ls_export_pkg to exp_full_database;
Not positive, but I think that's all I needed to do.
|
|
|
|