From: fvanbortel@netscape.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)