Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problems when I try to import database from Ora7 to Ora8!

Problems when I try to import database from Ora7 to Ora8!

From: Henrik Meldgaard Frisk <hfr_at_bang-olufsen.dk>
Date: Fri, 19 Nov 1999 14:59:48 +0100
Message-ID: <813l4o$6pi$1@news.inet.tele.dk>


Hi everyone.

I have a problem with my Oracle database on a UNIX system. I hope where is someone there can help me.

I have exported my database from Oracle 7.3.2.2 into a binary file whitout any errors. Now I want to import it into a Oracle 8.0.5.0.0 but when I try that I get the following 3 errors:

IMP-00019: row rejected due to Oracle message code num Cause: Import encountered the referenced Oracle error while trying to import a row.
Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.

IMP-00003: Oracle message code num encountered Cause: Import encountered the referenced Oracle error. Action: Look up the Oracle message in the ORA message chapters of this manual, and take appropriate action.

ORA-00001: unique constraint table.column violated Cause: An update or insert statement attempted to insert a duplicate key. Action: Either remove the unique restriction or do not insert the key.

Can anyone give me a clue.

Please reply to this address hfr_at_bang-olufsen.dk

Henrik
DK-Denmark Received on Fri Nov 19 1999 - 07:59:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US