| PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared [message #69635] |
Mon, 11 February 2002 19:40  |
manjunath raju
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
hi,
when i export the scheme , i get this error at end
About to export the schema ...
. 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.
|
|
|
|
| Re: PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared [message #69638 is a reply to message #69635] |
Tue, 12 February 2002 08:52  |
INTROV
Messages: 20
Registered: February 2002
|
Junior Member |
|
|
PLS-00201 identifier 'string' must be declared
Cause: An attempt was made to reference either an undeclared variable,
exception, procedure, or other item, or an item to which no privilege was
granted or an item to which privilege was granted only through a role.
Action:
1. Check your spelling and declaration of the referenced name.
2. Verify that the declaration for the referenced item is placed correctly in the
block structure.
3. If the referenced item is indeed declared but you do not have privileges to
refer to that item, for security reasons, you will be notified only that the
item is not declared.
4. If the referenced item is indeed declared and you believe that you have
privileges to refer to that item, check the privileges; if the privileges were
granted only via a role, then this is expected and documented behavior.
Stored objects (packages, procedures, functions, triggers, views) run in the
security domain of the object owner with no roles enabled except PUBLIC.
Again, you will be notified only that the item was not declared.
|
|
|
|
| Re: PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared [message #69677 is a reply to message #69635] |
Fri, 15 February 2002 08:39 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Not sure but I got a direct hit in MetaLink:
cause: Bug: 1828996
SYS.LT_EXPORT_PKG WARNING WHEN EXPORT USER HAS JUST
EXP_FULL_DATABASE ROLE
Export while exporting system procedural objects and actions expects the
'execute' privilege on those objects.
Script which installs LT_* packages should have the grants which is currently
missing.
So if you have LT_* objects there you go.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
