Home » RDBMS Server » Server Administration » Error During Export
Error During Export [message #63123] Mon, 13 September 2004 03:05 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Listener fail after change to shared server mode
Next Topic: How can I swap the multiple oracle home setting?
Goto Forum:
  


Current Time: Wed Dec 07 18:35:47 CST 2016

Total time taken to generate the page: 0.19235 seconds