Re: Import Question

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 27 Sep 2007 19:58:06 +0200
Message-ID: <fdgqv9$jno$1@news5.zwoll1.ov.home.nl>

-----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

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG++8uLw8L4IAs830RAh1TAKCbwloskb6ow3178x8tsNFg2zhe7QCfUNpR Du/0D3bGvsTwmafEUl+cNME=
=GLMi
-----END PGP SIGNATURE----- Received on Thu Sep 27 2007 - 12:58:06 CDT