Home » RDBMS Server » Server Utilities » "SYS.DBMS_EXPORT_EXTENSION" does not exist
"SYS.DBMS_EXPORT_EXTENSION" does not exist [message #71732] Mon, 30 December 2002 07:58 Go to next message
constantin mitocaru
Messages: 2
Registered: December 2002
Junior Member
I have Oracle 8.0.5 running on Windows NT 2000 Server.
While trying to export tables using @ORACLE_HOMEbinexp80 I get the following error.
I must mention that I ran the catproc.sql script and utlrp.sql. However I'm getting 191 invalid objects when running:

select object_name, object_type, status, owner from dba_objects where status='INVALID';

Could someone help?

Here is the exception
--------------------------------------------
. . exporting table IMDTB_DOCS
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.DBMS_EXPORT_EXTENSION" does not exist

ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Re: "SYS.DBMS_EXPORT_EXTENSION" does not exist [message #71733 is a reply to message #71732] Mon, 30 December 2002 08:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
login as sys
first run catalog.sql
then catproc.sql
try again.~!
Re: "SYS.DBMS_EXPORT_EXTENSION" does not exist [message #71746 is a reply to message #71732] Fri, 03 January 2003 17:54 Go to previous messageGo to next message
constantin mitocaru
Messages: 2
Registered: December 2002
Junior Member
Thank you, it worked!
Re: [message #517094 is a reply to message #71746] Fri, 22 July 2011 07:52 Go to previous message
Cybe
Messages: 1
Registered: June 2005
Location: Paris
Junior Member
Thanks Mahesh, it was a great help !
Previous Topic: Partition Export Syntax(4 Merged)
Next Topic: sql loader help
Goto Forum:
  


Current Time: Thu Aug 28 18:20:59 CDT 2014

Total time taken to generate the page: 0.19248 seconds