Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Full import ends with errors

Re: Full import ends with errors

From: simone griffin <simonemg_at_online.no>
Date: Sun, 24 Jan 1999 00:11:08 +0100
Message-ID: <78dl3f$gjp$1@readme.online.no>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US