Re: Problem with IMPORT

Venkat

Do you have Indexes=N and also as far as I'm aware the import does not disable the constraints but will re-enable. I have success when I disable the constraints first before the import.

Try it and let us know how it goes.

HTH Colin
Venkat wrote in message <6k4psc$h76_at_dfw-ixnews4.ix.netcom.com>...
>I am trying to import an export file (USER export) using FROMUSER/TOUSER.
The export was
>done in DIRECT mode (7.3.3). When I run import logged in as the DBA that
created the
>export file and FROMUSER/TOUSER (ignore=Y. I pre-created all the objects
with new storage
>settings), it is giving me all kinds of Integrity constraint violated -
Primary Keys not
>found errors. What am I doing wrong ?
>Is it because I precreated the tables with all the constraints intact? The
import is done
>in alphabetical order so I can see why the errors are occurring. I
thought import
>disables all constraints and enables them at the end
>
>Thanks in advance
>
>Venkat
>
>
>
Received on Sat May 23 1998 - 20:51:06 CDT