Import object order problem

From: <Jim.Pickett_at_cubic.com>
Date: Tue, 21 Sep 1999 13:32:12 -0800
Message-ID: <Forum.937946547.2144.Pickett@ferret>

Dear fellow Readers -

I'm doing an import of an exported 7.3.3.5 database and have discovered an ordering problem

with the import file. ( I am exporting a username which owns a set of objects, dropping/recreating

the owner, then immediately importing the just created export file ).

The problem appears to be with a view that references a function. The create view DDL statement

is processed BEFORE the create function DDL from the import file causing the view to be

'INVALID' . Because of the invalid status, subsequent grants of privs to the view to fail leaving

me with a bit of a mess to manually clean up.

Has anyone else experienced this behaivor with the Oracle7 import function ?

Regards, Jim

Received on Tue Sep 21 1999 - 16:32:12 CDT