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_at_posting.google.com>
Date: 14 Jan 2004 07:24:27 -0800
Message-ID: <e4e5e80f.0401140724.60715c0a_at_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 - 16:24:27 CET