Re: Export/Import problem

R.A. Joemman wrote:
> 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

This will teach you not to name your contraints! No other way that to query afterwards (your unnamed constraints will be there) and enable them

-- 

Regards,
Frank van Bortel