Re: Integrity Constraints
From: Joseph Strano <stranoj.dulcian_at_postoffice.worldnet.att.net>
Date: 1997/02/11
Message-ID: <330106DA.228B_at_postoffice.worldnet.att.net>#1/1
Date: 1997/02/11
Message-ID: <330106DA.228B_at_postoffice.worldnet.att.net>#1/1
Michael Sevy wrote:
>
> If I do a full export of my database and specify CONSTRAINTS=Y, then I
> drop all the tables and do an import, is Oracle smart enough to
> export/import the tables in the proper order - ie Parent Tables and then
> Child Tables ? In the documentation they keep talking about having to
> do an ALTER TABLE xxx DISABLE CONSTRAINT before the import. Makes me
> wonder if Oracle does any ordering of the tables at all.
>
> Any comments, suggestions, workarounds?????
I have performed this task many times without failure. Oracle does everything in the right order.
Joe Strano
Dulcian Inc.
Received on Tue Feb 11 1997 - 00:00:00 CET