Hi david,

Run the script ans after it run the result of it :

as system :

select 'alter ' || object_type || ' ' || owner || '.' || object_name ||
' compile;'
from all_objects where object_type = 'VIEW' and owner='XXXXX';


or as user

select 'alter ' || object_type || ' ' || object_name || ' compile;'
from user_objects where object_type = 'VIEW' ;

Noraldino.


David NGUYEN wrote:

>hi experts
>
>is there a way to compile all views of a schema ..? or i have to compile
>view by view..?
>what is the query for that..?
>
>thanks in advance.
>
>david..
>(See attached file: C.htm)
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>
>



Oracle LazyDBA home page