Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 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 CST