OraFAQ Forum: Server Utilities » Export time problem (merged)

Home » RDBMS Server » Server Utilities » Export time problem (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export time problem (merged) [message #253245]

Mon, 23 July 2007 05:01

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.

Report message to a moderator

Re: Export Time Error [message #253248 is a reply to message #253245]

Mon, 23 July 2007 05:08

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.

Report message to a moderator

Re: Export Time Problem [message #253249 is a reply to message #253245]

Mon, 23 July 2007 05:09

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Duplicate post..

Report message to a moderator

Re: Export Time Problem [message #253251 is a reply to message #253245]

Mon, 23 July 2007 05:10

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

may i know your exp. command..

and send me log file.

Report message to a moderator

Re: Export Time Problem [message #253256 is a reply to message #253249]

Mon, 23 July 2007 05:15

shailendra_gohil
Messages: 4
Registered: July 2007

Junior Member

I dont find XDB.DBMS_XDBUTIL_INT package.

Report message to a moderator

Re: Export Time Problem [message #253259 is a reply to message #253245]

Mon, 23 July 2007 05:20

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.

Report message to a moderator

Re: Export Time Problem [message #253324 is a reply to message #253259]

Mon, 23 July 2007 09:13

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

check it

http://tek-tips.com/viewthread.cfm?qid=1202176&page=6

Report message to a moderator

Re: Export Time Problem [message #253473 is a reply to message #253259]

Tue, 24 July 2007 01:33

shailendra_gohil
Messages: 4
Registered: July 2007

Junior Member

OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_XDBUTIL_INT
DBMS_XDBUTIL_INT
DBMS_XDBUTIL_INT
3 rows selected

Report message to a moderator

Re: Export time problem (merged) [message #253476 is a reply to message #253245]

Tue, 24 July 2007 01:43

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?

Report message to a moderator

Re: Export time problem (merged) [message #253484 is a reply to message #253476]

Tue, 24 July 2007 01:57

shailendra_gohil
Messages: 4
Registered: July 2007

Junior Member

While Compiling it throws error like:

Package body altered with compilation error.

Report message to a moderator

Re: Export time problem (merged) [message #253677 is a reply to message #253484]

Tue, 24 July 2007 10:37

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

what error it throws?

Report message to a moderator

Re: Export time problem (merged) [message #253692 is a reply to message #253484]

Tue, 24 July 2007 11:14

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

show errors
(this is a command not a request... after all, this is also a request)

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 04:50:39 CST 2025