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