| error while exporting [message #153080] |
Wed, 28 December 2005 22:48  |
kinjal
Messages: 124
Registered: June 2001
|
Senior Member |
|
|
Hi,
When I try to export the database, following error appears.
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 able to understand how to solve it.
Can anyone please help me?
Kinjal
|
|
|
|
|
|
|
|
| Re: error while exporting [message #153084 is a reply to message #153083] |
Wed, 28 December 2005 23:36  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Log in as SYS and post the output of the following query
SQL> select owner,object_name,object_type
2 from dba_objects
3 where object_name like 'LT_EXPORT%'
4 and owner='SYS';
The output will tell you about the existence of the package on your machine.
|
|
|
|
| Re: error while exporting [message #153085 is a reply to message #153080] |
Wed, 28 December 2005 23:40 |
kinjal
Messages: 124
Registered: June 2001
|
Senior Member |
|
|
Hi Tarun,
Following is the output..
No package called lt_export_pkg is there
Output:
SQL> select owner,object_name,object_type
2 from dba_objects
3 where object_name like 'LT_EXPORT%'
4 and owner='SYS';
no rows selected
SQL>
|
|
|
|
| Re: error while exporting [message #153088 is a reply to message #153080] |
Thu, 29 December 2005 00:07 |
kinjal
Messages: 124
Registered: June 2001
|
Senior Member |
|
|
hi,
I have found which script to run.
Its owminst.plb
I have run it.
And I have also run catexp.sql
Now I am again checking whether any error is there now or not while exporting.
Kinjal
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
