Re Compile the VIEW

[Kashif]

Asslam-o-Alaikum.

Dear all members.

If i have a Veiw, Created from More then ONE Table.
When ever i any DDL Operation Made on any table partcipating in the VIEW.
Every time i have to RECOMPLIE the View. Either by Running the Full Script for creating the VIEW or From Enterprise Mangment Console.

Is there any easy way to RECOMPILE the VEIW in the Single statement in SQL PLUS.

i think i have not left any thing which is not understandable.
if any please let me know. i will explain.

Thanks to all

Best Regards.

Muhammad Kashif

[admin]

You have tried DBMS_UTILITY.compile_schema?