Full Export/Import Ora 7.2

From: Doug Harris <dharris_at_gov.nb.ca>
Date: 1997/01/13
Message-ID: <01bc0150$be9860c0$88238b8e@dharris.gov.nb.ca>#1/1

On Oracle 7.2 running on a SCO OpenServer 5.0 platform, a full db export runs normally without error or warning.

However a full import produces errors when importing views and processing grants on those views.
The views in error use a custom function.

Export appears to process procedures last and import also appears to import those procedures before views so that the views are imported with the FORCE option and grants on those views fail because they are considered invalid.

Has anyone encountered this problem and discovered a fix? Received on Mon Jan 13 1997 - 00:00:00 CST