Re: Question about imports

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 20 Oct 1999 20:25:37 +0800
Message-ID: <380DB4C1.2343@yahoo.com>

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.

Import tries to preserve most dependencies - but in any case, once you've imported check STATUS on DBA_OBJECTS to recompile or use dbms_utlity.comile_schema (its something like that)

HTH --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Oct 20 1999 - 07:25:37 CDT