Hi
I am using the following query for findout Invalid views.
select creator,name,check
from sysbac.sysview
where valid <> 'Y' with UR;
I will get all invalid views..But I have to re-compile all views in a single statement. is it possible? Now I am taking every view name and open the sql script and reexcuting. If I have more than 10 views..it is very difficult.
Can you please provide me a solution on this..!!!
Thanks alot in adv.
Regards
Sa