Home » RDBMS Server » Server Utilities » Export time problem (merged)
Export time problem (merged) [message #253245] Mon, 23 July 2007 05:01 Go to next message
shailendra_gohil
Messages: 4
Registered: July 2007
Junior Member
I am using Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production.

I am facing following error when I try to export

. exporting triggers
EXP-00056: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00056: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

Please provide solution for this problem

Thanks,
Shailendra.
Re: Export Time Error [message #253248 is a reply to message #253245] Mon, 23 July 2007 05:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Delete XDB.DBMS_XDBUTIL_INT package and try export again.

ATTENTION: This may be harmful.
Re: Export Time Problem [message #253249 is a reply to message #253245] Mon, 23 July 2007 05:09 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Duplicate post..
Re: Export Time Problem [message #253251 is a reply to message #253245] Mon, 23 July 2007 05:10 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


may i know your exp. command..

and send me log file.
Re: Export Time Problem [message #253256 is a reply to message #253249] Mon, 23 July 2007 05:15 Go to previous messageGo to next message
shailendra_gohil
Messages: 4
Registered: July 2007
Junior Member
I dont find XDB.DBMS_XDBUTIL_INT package.
Re: Export Time Problem [message #253259 is a reply to message #253245] Mon, 23 July 2007 05:20 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Conenct as sys user and use ,
 select object_name from dba_objects where object_name like '%DBMS_XDBUTIL_INT%';

and paste your output here.
Re: Export Time Problem [message #253324 is a reply to message #253259] Mon, 23 July 2007 09:13 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
check it

http://tek-tips.com/viewthread.cfm?qid=1202176&page=6
Re: Export Time Problem [message #253473 is a reply to message #253259] Tue, 24 July 2007 01:33 Go to previous messageGo to next message
shailendra_gohil
Messages: 4
Registered: July 2007
Junior Member
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_XDBUTIL_INT
DBMS_XDBUTIL_INT
DBMS_XDBUTIL_INT
3 rows selected
Re: Export time problem (merged) [message #253476 is a reply to message #253245] Tue, 24 July 2007 01:43 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Compile the package. Are you trying to export one schema to another schema user?
Re: Export time problem (merged) [message #253484 is a reply to message #253476] Tue, 24 July 2007 01:57 Go to previous messageGo to next message
shailendra_gohil
Messages: 4
Registered: July 2007
Junior Member
While Compiling it throws error like:

Package body altered with compilation error.
Re: Export time problem (merged) [message #253677 is a reply to message #253484] Tue, 24 July 2007 10:37 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
what error it throws?
Re: Export time problem (merged) [message #253692 is a reply to message #253484] Tue, 24 July 2007 11:14 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show errors
(this is a command not a request... after all, this is also a request)

Regards
Michel
Previous Topic: Need help on unix shell scripting for sqlloader
Next Topic: sqlldr loading wrong date 12/31/1999
Goto Forum:
  


Current Time: Fri Dec 09 13:37:15 CST 2016

Total time taken to generate the page: 0.30897 seconds