Home » RDBMS Server » Server Utilities » Import with broken Export possible?
Import with broken Export possible? [message #275286] Fri, 19 October 2007 04:08 Go to next message
twadorno
Messages: 8
Registered: June 2007
Junior Member
Hi my dear forum,

I have a horrible problem.
today I got a Oracle-dump, that was made with the exp-command.
No one was checking the logs, but there was written


Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
...

About to export specified tables via Direct Path ...
. . exporting table                       TB-NAME
...........................................................................

                                                     95403536 rows exported
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 30:
PLS-00905: object XDB.DBMS_XDBUTIL_INT is invalid
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 30:
PLS-00905: object XDB.DBMS_XDBUTIL_INT is invalid
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully



Now I must import the file.
It must be possible, because I have no chance to make a new dump.

Maybe some things are broken - I need only the datas. All other Tables was without any problems.

How can help me?

Thanks
Re: Import with broken Export possible? [message #275292 is a reply to message #275286] Fri, 19 October 2007 04:33 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you execute xdbpatch after last patchset application?
You can also reinstall xdb. Have a look at Metalink note 243554.1 "How to Deinstall and Reinstall XML Database (XDB)".

Regards
Michel
Previous Topic: IMP-00017: following statement failed with ORACLE error 3113
Next Topic: Problem with Large Import on Windows-Machine
Goto Forum:
  


Current Time: Wed Jun 26 13:52:15 CDT 2024