Home » RDBMS Server » Server Utilities » export error
export error [message #242286] Fri, 01 June 2007 08:29 Go to next message
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 #242295 is a reply to message #242286] Fri, 01 June 2007 08:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try rerun catexp.sql
Then utlrp.sql.
Connected as SYS, of course.

Regards
Michel

[Updated on: Fri, 01 June 2007 09:00]

Report message to a moderator

Re: export error [message #242296 is a reply to message #242286] Fri, 01 June 2007 09:16 Go to previous messageGo to next message
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.
Re: export error [message #242339 is a reply to message #242296] Fri, 01 June 2007 11:04 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Follow the thread ORA-00604 problem

Regards
Michel
Previous Topic: importing sql server database
Next Topic: Import skips table
Goto Forum:
  


Current Time: Sun Dec 11 02:01:30 CST 2016

Total time taken to generate the page: 0.09199 seconds