| Export error while run the export command [message #209574] |
Fri, 15 December 2006 11:00  |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
