Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Integrity Constraints

Re: Integrity Constraints

From: Joseph Strano <stranoj.dulcian_at_postoffice.worldnet.att.net>
Date: 1997/02/11
Message-ID: <330106DA.228B@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US