Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import Question
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
![]() |
![]() |