What is the purpose of FORCE while creating a VIEW

Showing Answers 1 - 2 of 2 Answers


  • Jun 3rd, 2006

usually the views are created from the basetable if only the basetable exists.

The purpose of FORCE keyword is to create a view if the underlying base table doesnot exists.

ex : create or replace FORCE view <viewname> as <query>

while using the above syntax to create a view the table used in the query statement doesnot necessary to exists in the database


  • May 9th, 2007

Dear Rajeswaran,
Please give one example(application) where one can use force view.
Thanks & regards

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions