R: problems with migration from Oracle 7.1 to 8.0.3

From: Enzo De Caro <edecaro_at_tiscalinet.it>
Date: Wed, 21 Jul 1999 14:57:41 +0200
Message-ID: <7n4g34$36t$1@aquila.tiscalinet.it>

The problem has differents solution depending on what you want to do...

The errors are due to the fact that the rows you try to import already exists in that table...

You can avoid this by DISABLEing the constraints with

ALTER TABLE table DISABLE CONSTRAINT constraint_name

but this will cause rows duplication on import and you will not be able to re-ENABLE the constraints again until you delete dups rows...

Rgds.
Enzo De Caro.

Mike Haegele <ubshag_at_rabbit.mchp.siemens.de> wrote in message 378AF42A.1FF93FF_at_rabbit.mchp.siemens.de...
> Hi,
>
> I have some problems with an full import into Oracle 8.
> The export from Oracle 7.3 works without errors and warnings,
> but the import makes trouble.
> The log file traces the following errors:
>
> imported
> . . importing table "PERABA"
> IMP-00019: row rejected due to ORACLE error 1
> IMP-00003: ORACLE error 1 encountered
> ORA-00001: unique constraint (PERSO.PK_KIRCH_PERABA) violated
> Column 1 28
> Column 2 Deutsche Produktion
> Column 3 P 5
>
> Due to this I have also problems to impert tables with foreign keys.
>
> Who can help me?
>
> Mike
>
>
Received on Wed Jul 21 1999 - 07:57:41 CDT