| export error [message #242286] |
Fri, 01 June 2007 08:29  |
plshelp
Messages: 205
Registered: January 2007
|
Senior Member |
|
|
Hi all,
I am got the below error when the export was ran last night..The database was upgraded from 8.1.7.4 to 9.2.0.7 on solaris 9 about 3months back. The export was running fine all this time. Below is the error I got:
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_EXPORT_EXTENSION" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Please advise if you have clues of whats going on.
Thanks much
|
|
|
|
|
|
| Re: export error [message #242296 is a reply to message #242286] |
Fri, 01 June 2007 09:16  |
plshelp
Messages: 205
Registered: January 2007
|
Senior Member |
|
|
Michael,
Before that I want to drop the test tablespace I created yesterday. And then I want to run the scripts that you mentioned.
I have removed all the tables in the test tablespace and when I tried to remove the tablespace its ending up with the below error:
SQL> drop tablespace test including contents and datafiles;
drop tablespace test including contents and datafiles
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
I see in OEM, the tablespace is 1.15% used.. Please advise how I can remove this tablespace..Thank you very much for your support.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
