Drop 是DDL语句,作用于元数据
sys@ORCL> create table t2 as select * from dba_source;
Table created.
sys@ORCL> insert into t2 select * from t2;
292781 rows created.
sys@ORCL> insert into t2 select * from t2;
585562 rows created.
sys@ORCL> insert into t2 select * from t2;
1171124 rows created.
sys@ORCL> select count(*) from t2; --200多W数据
COUNT(*)
----------
2342248
sys@ORCL> drop table t2; --这里我ctrl+c终止掉
drop table t2
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01013: user requested cancel of current operation
sys@ORCL> select count(*) from t2;
select count(*) from t2
*
ERROR at line 1:
ORA-00942: table or view does not exist