SQL>
SQL>
SQL> create view invalid_view as
2 select * from table_that_does_not_exist;
select * from table_that_does_not_exist
*
ERROR at line 2:
ORA-00942: table or view does not exist
SQL>
SQL> create force view invalid_view as
2 select * from table_that_does_not_exist;
Warning: View created with compilation errors.
SQL>
SQL> drop view invalid_view;
View dropped.
SQL>
SQL>