| Error During Export [message #63123] |
Mon, 13 September 2004 03:05  |
M Kumar
Messages: 38
Registered: August 2004
|
Member |
|
|
Hi All,
I am getting a error while export but its creating required DMP file.
Is it Serious?Log file is attached for reference.
Connected to: Oracle9i Release 9.0.1.1.1 - Production
JServer Release 9.0.1.1.1 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-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 foreign function library names for user PRDNUSR
. exporting object type definitions for user PRDNUSR
About to export PRDNUSR's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export PRDNUSR's tables via Conventional Path ...
. . exporting table DPIC 1 rows exported
. . exporting table EMP 3 rows exported
. . exporting table IMAGETEST 0 rows exported
. . exporting table LABEL_DATA 309 rows exported
. . exporting table MTHTAB 2 rows exported
. . exporting table P1 1 rows exported
. . exporting table P_GRD_MAS 6 rows exported
. . exporting table P_PRDN_MAS 140147 rows exported
. . exporting table P_PROD_MAS 1176 rows exported
. . exporting table P_TRF_SLIP 1 rows exported
. . exporting table S1 25 rows exported
. . exporting table SHE_ACCDT_DTL 7 rows exported
. . exporting table SHE_CLASSIFY 82 rows exported
. . exporting table SHE_DEPT_MAS 20 rows exported
. . exporting table SHE_EMP_MAS 357 rows exported
. . exporting table SHE_MANHOUR_MAS 38 rows exported
. . exporting table SHE_SUBCOM_MAS 7 rows exported
. . exporting table XP_PRDN_MAS 308 rows exported
. 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.
Thanks in Advance
|
|
|
|
| Re: Error During Export [message #63124 is a reply to message #63123] |
Mon, 13 September 2004 03:43  |
nabila
Messages: 13
Registered: April 2003
|
Junior Member |
|
|
fix:
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;
|
|
|
|
| Re: Error During Export [message #64164 is a reply to message #63123] |
Thu, 23 December 2004 23:53 |
Ntw
Messages: 1
Registered: December 2004
|
Junior Member |
|
|
I tried to fix it by
fix: (By Nabila)
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;
It still occured this error (below)
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
Thanks in advance
|
|
|
|
| Re: Error During Export [message #195284 is a reply to message #63123] |
Wed, 27 September 2006 15:34 |
shiki
Messages: 2
Registered: December 2005
Location: USA
|
Junior Member |
|
|
Symptoms
Export of 9.2.0.6 database fails with following errors:
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling
SYS.LT_EXPORT_PKG.system_i
Verified the issue by the log file fullexp050206.log
Cause
WORKSPACE , XDB schemas have invalid objects.
Fix
Run $ORACLE_HOME/rdbms/admin/owminst.plb as SYS to allow the LT_EXPORT_PKG to be validated.
|
|
|
|
| Re: Error During Export [message #195285 is a reply to message #63123] |
Wed, 27 September 2006 15:35 |
shiki
Messages: 2
Registered: December 2005
Location: USA
|
Junior Member |
|
|
Hi Here is the solution............
try this
Symptoms
Export of 9.2.0.6 database fails with following errors:
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling
SYS.LT_EXPORT_PKG.system_i
Verified the issue by the log file fullexp050206.log
Cause
WORKSPACE , XDB schemas have invalid objects.
Fix
Run $ORACLE_HOME/rdbms/admin/owminst.plb as SYS to allow the LT_EXPORT_PKG to be validated.
Thanks
Shiki
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
