Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Full import ends with errors
Hi.
You could also run the import one more time with rows=n ......
Best regards
Kai Horstmann wrote in message <36A8DE78.D3002F15_at_werum.de>...
>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 Sat Jan 23 1999 - 17:11:08 CST