SQL> create table c (a int);
表已创建。
SQL> create view vc as select * from c;
视图已创建。
SQL> alter table c modify (a varchar(10));
表已更改。
SQL> select object_name,object_type,status from dba_objects where object_name='VC';
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
VC
VIEW
INVALID
SQL> alter session set sql_trace=true;
会话已更改。
SQL> select *from vc;
未选定行
SQL> alter session set sql_trace=false;
会话已更改。
SQL> select object_name,object_type,status from dba_objects where object_name='VC';
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
VC
VIEW
VALID