Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why are my imported Views invalid?
Hi!
Maybe the views that became invalid uses objects that wasn't in the dictionary on the moment of importing of views. For example this could happen if some view uses some function, and Import process functions AFTER processing views.
You can fix it with this simple script:
set pause off
spool 1.sql
select 'alter view '||object_name||' compile;'
from USER_OBJECTS
where object_type = 'VIEW'
and status = 'INVALID';
spool off
@1.sql
Lito Dizon wrote:
>
> I exported a user's schema from a OWG Server 7.2, then imported it to a
> PO7 database. Some of the imported views are invalid. Any insight why
> this happens?
>
> Thanks,
> Lito
-- Regards. Alexey Neckrasow. Leaves Inc. Russia. e-mail: nec_at_leaves.spb.suReceived on Mon Apr 14 1997 - 00:00:00 CDT