drop a backend table then query the view
SQL>
SQL> create table t(
2 id number,
3 data varchar2(200) );
Table created.
SQL>
SQL>
SQL> create or replace view view_t as
2 select id view_id, data view_data
3 from t;
View created.
SQL>
SQL> drop table t;
Table dropped.
SQL>
SQL> select * from view_t;
select * from view_t
*
ERROR at line 1:
ORA-04063: view "JAVA2S.VIEW_T" has errors
SQL>
SQL>
SQL>
Related examples in the same category