Re: Integrity Constraints

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 not done an export/import in a while, but I believe that Oracle restores the constraints after putting all of the data back in the all of the tables. So restoring tables is still in alpha order.

-- 
Thomas Griffin
Project Leader
QUALITECH Systems, Inc.
tgriffin_at_qualitech.com