What is the meaning of “FORCE” in a view statement?
Usually, you create a new view based on existing tables.However, sometimes, you may want to create a view based on tables:
- which you will create later
- where you don’t have sufficient privileges to access the table during the creation time of the view.
In these cases, you can use the
FORCE option and so the compilation of the view(s) will be successful.