Export/Import problem

From: R.A. Joemman <raoul.joemman_at_wanadoo.nl>
Date: 14 Jan 2004 07:24:27 -0800
Message-ID: <e4e5e80f.0401140724.60715c0a@posting.google.com>

Hi,

We are migrating a database from Oracle 8.1.7.0.0 to Oracle 9.2.0.1.0 on AIX.
Export as follows:

exp ${user}/${pwd} compress=n file=${file} log=${log} owner=${schema} grants=y indexes=y rows=y constraints=y

Then import as follows:

imp ${user}/${pwd} file=${file} log=${log} full=y

On import we get errors because of the constraint names are renamed by the target dbms:

IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "xxx" ENABLE NOVALIDATE CONSTRAINT "SYS_C003875""

The DBMS has renamed the constraint from SYS_C003875 to SYS_C004600. So the above statement fails.
How do we tell the DBMS to not rename the constraints?

Best regards
Raoul Received on Wed Jan 14 2004 - 09:24:27 CST