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: Question about imports

Re: Question about imports

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sun, 31 Oct 1999 16:15:20 +0100
Message-ID: <381C5D08.292450DF@0800-einwahl.de>


Try to export it with the option "consistent=y".

Martin

amerar_at_ci.chi.il.us wrote:
>
> Hello,
>
> An interesting question. When you do a full database export, it exports
> everything, tables,. constraints, indexes, procedures, functions, etc.
>
> When I then do a full import, how can I make it such that the object
> dependencies are not in error?
>
> For example, I have Table A with a foreign key in Table B. If the
> import brings in Table A first, the creation of the constraint will
> fail.
>
> Likewise, if any procedures are brought in and compliled before the
> functions, they will probably fail too.....
>
> Can this be fixed?
>
> Arthur
> amerar_at_ci.chi.il.us
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Oct 31 1999 - 09:15:20 CST

Original text of this message

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