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

Hi Henrik,

We had a similar problem.

In our case the creation of the target database was done with an 8-bit characterset and our export file was created with a session where the environment variable ORA_NLS33 was not properly. So the export file was created with the default 7-bit characterset US7ASCII and it therefore contained the same entry for two values that were different in the source database. We only noticed the error on importing into the target database when we tried to establish the unique constraints.

Martin

Henrik Meldgaard Frisk wrote:
>
> 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 Sat Nov 27 1999 - 14:02:42 CST