Home » RDBMS Server » Server Administration » Export error while run the export command
Export error while run the export command [message #209574] Fri, 15 December 2006 11:00 Go to next message
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
Member
hai sir

I need your help when i run the export command the following error is thrown plz help me ..

oracle version :9.2.0.7.0

EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REFRESH_EXP_LWM" 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.DBMS_REFRESH_EXP_LWM.schema_info_exp

same error for:
SYS.DBMS_REFRESH_EXP_LWM
SYS.DBMS_REPCAT_RGT_EXP
SYS.DBMS_LOGREP_EXP

i am connected sys user
>select status from user_objects where object_name='DBMS_REFRESH_EXP_LWM';

it shows o/P:
package invalid
packagebody invalid

after that i did
>alter package DBMS_REFRESH_EXP_LWM compile;
it show s package is not created..
then
>select status from user_objects where object_name='DBMS_REFRESH_EXP_LWM';

it shows o/P;
package valid
packagebody invalid

plz help me to fix this error
-advanced thank u

Re: Export error while run the export command [message #209586 is a reply to message #209574] Fri, 15 December 2006 13:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you try this?
http://www.orafaq.com/forum/m/70586/42800/?srch=DBMS_REFRESH_EXP_LWM#msg_70586
Re: Export error while run the export command [message #209609 is a reply to message #209574] Fri, 15 December 2006 21:30 Go to previous messageGo to next message
dba_blr
Messages: 43
Registered: December 2006
Member
Run catalog.sql & catproc.sql.
Re: Export error while run the export command [message #209612 is a reply to message #209609] Fri, 15 December 2006 21:42 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
dba_blr wrote on Fri, 15 December 2006 22:30
Run catalog.sql & catproc.sql.

YEP...exactly what Mahesh suggested in his link.
Previous Topic: Listener 10g and 8i
Next Topic: changing the size of log_buffer
Goto Forum:
  


Current Time: Wed Dec 07 10:57:05 CST 2016

Total time taken to generate the page: 0.08725 seconds