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: Import Question

Re: Import Question

From: Hasta <hasta_l3_at_hotmail.com>
Date: Thu, 27 Sep 2007 21:59:00 +0200
Message-ID: <MPG.216629ef959cff6d989689@news.dommel.be>


In article <fdgqv9$jno$1_at_news5.zwoll1.ov.home.nl>, frank.van.bortel_at_gmail.com says...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hasta wrote:
> >>
> >> It's not just about constraints or the order of tables.
> >> The original question was more generic, and yes, sometimes
> >> you'll get errors because dependent objects do not
> >> (yet) exist: procedures, functions, packages and views to name
> >> a few, can either be invalid and need to be recompiled, or are
> >> not created at all, which can happen with views.
> >>
> >
> > Woaw ! When is a view not created at all, Frank ?
> >
>
> Whenever you have a 'Synonym translation no longer valid'
> (ORA-00940?) error. Howard will probably argue this is not
> an import error, but a user error.
> It is not - it is simply the sequence in which import
> handles objects. Rerun the import with ignore=y
> and rows=n, and it should be OK.
>
> - --
> Regards,
> Frank van Bortel

Thanks, Frank Received on Thu Sep 27 2007 - 14:59:00 CDT

Original text of this message

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