hi expertsis there a way to compile all views of a schema ..? or i have to compileview by view..?what is the query for that..?thanks in advance.david..(See attached file: C.htm)Oracle LazyDBA home page