Re: Full import ends with errors

Karol Michaliak wrote:
>
> The problem is that if in export file are views, triggers and other
> objects, which depends
> on the other ones, which are not yet imported the import of such

Let the import create a logfile.

Objects of type trigger, view function, procedure and package are easy to handle:

A simple "alter <object type> <object name> compile;" should do it, if really all dependent object are present after the import.

you could do this job with a PL/SQL block that examines all objects of the types above from dba_objects except the ones from owner SYS and compiles them using dynamic SQL.

Good luck,
Kai Received on Fri Jan 22 1999 - 14:24:24 CST