Re Compile the VIEW
Posted: Fri Jun 30, 2006 8:32 am
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
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