Re: Problem with IMPORT

From: Mick McRae <Mick.McRae_at_its.csiro.au>
Date: Mon, 25 May 1998 13:27:36 +1100
Message-ID: <3568E527.4AE8D175@its.csiro.au>

Hi,

I have just had a similar situation. I had to pre-create about six tables to adjust storage paramters, and then import the entire user schema - about 30 tables. When creating the six tables, I created them without the constraints. Imported the database schema which enabled all constraints after the data was loaded.

Regards,
Mick

Venkat wrote:

> 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 Sun May 24 1998 - 21:27:36 CDT