aseemnaithani

 Profile Answers by aseemnaithani Questions by aseemnaithani

• May 4th, 2006

 

hi,

we create force view when we are not sure about the table name. In otherwords force views can be created on a table or view which doesn't exists in the database.

amit

• May 13th, 2006

 

You can only create a view with errors by using the FORCE option, error can be table does not exists or if there are not enough priviliges on objects used in views. In this case view will be created and refrence will be added in dictionary table but will be in invalid state.

Lavanya Chowdary

• May 6th, 2007

 

Generally we are not supposed to create a view without base table. If you want to create any view without base table that is called as Force View or invalid view.?
Syntax: CREATE FORCE VIEW AS < SELECT STATMENT >;
That View will be created with the message
View created with compilation errors
Once you create the table that invalid view will become as valid one.

g_sidhu

 Profile 

• Feb 1st, 2008

 

Force View: creates the view regardless of whether or not the base tables exist or whether the user has privileges on them. The user still can’t execute the view, but he or she can create it. Normally if there is an error in the viewdefinition, the view is not created. If you add the keyword 'force', the view is created anyway.