Hi

As per Oracle Documentation a view can be created without existence of Base table and not to replace a view. As two views can not be created with same name.

I have tried to create view with option FORCE without a table but recieved an exception ORA-00942: table or view does not exist

Can any one pls suggest hot to use this FORCE option pls mail me at vishnu.sriramula@gmail.com.

Thanks in advance

vishnu

Hi

A view can be created without existence of Base table and not to replace a view. As two views can not be created with same name.

/*Actually one more thing important is that u can create view without the defination of table With force option. it will be create but the status of the view will be invalid*/

Regards

Pawan Ahuja

919342927335

hi

Its impossible to create a view without a base table.

I request you to check out that documentation once again properly

Hi All

Force view is created only when you want to create a view for which base table doesnt exist. As it will only create view but could not be used because it will be in invalid mode.

It will come in valid mode only when you will create respective base table and recompile the view.

For example:

Suppose we try to create a view vw_emp on a non existing table emp.

SQL> Create View vw_emp as Select empid empname from emp;

This command will give an error ORA-000942.

However if we use the FORCE option it will create the view.However trying to access the view gives an error because the table 'emp' doesnt exist.

SQL> Create FORCE VIEW vw_emp as select empid empname from emp;

It will give a warning: View created with compilation error.

Force option used to create a view without existance of Table in the database

Syntax: Create or replace FORCE VIEW as select * from <non-exist tab name>

Thanks&Regds

Ramki TCS Hyd 9989018508