CREATE OR REPLACE FORCE VIEW

What is the meaning of “FORCE” in a view statement?

FORCE

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.

Leave a Reply

Close Menu