Table altered.

gc1:

SQL>select * from test1;

EMPNOENAME JOB MGR HIREDATE SAL COMM DEPTNO

---------- ---------- --------- ---------------------- ---------- ---------- ----------

7369SMITH CLERK 7902 17-DEC-80 800 20

7499ALLEN SALESMAN 7698 20-FEB-81 1600 300 30

7521WARD SALESMAN 7698 22-FEB-81 1250 500 30

7566JONES MANAGER 7839 02-APR-81 2975 20

......?

验证ddl:drop操作

gc2:

SQL>select * from tab;

TNAME TABTYPE CLUSTERID

------------------------------ ------- ----------

BONUS TABLE

DEPT TABLE

EMP TABLE

SALGRADE TABLE

TCUSTMER TABLE

TCUSTORD TABLE

TEST1 TABLE

TEST2 TABLE

8 rows selected.

gc1:

SQL> drop table test1;

Table dropped.

gc2:

SQL>select * from tab;

TNAME TABTYPE CLUSTERID

------------------------------ ------- ----------

BONUS TABLE

DEPT TABLE

EMP TABLE

SALGRADE TABLE

TCUSTMER TABLE

TCUSTORD TABLE

TEST2 TABLE

7 rows selected.

gc1:

SQL>select * from tab;

TNAME TABTYPE CLUSTERID

------------------------------ ------- ----------

DEPT TABLE

EMP TABLE

BONUS TABLE

SALGRADE TABLE

TCUSTMER TABLE

TCUSTORD TABLE

TEST2 TABLE

7 rows selected.

gc2:

SQL>drop table test2;

Table dropped.

SQL>select * from tab;

TNAME TABTYPE CLUSTERID

------------------------------ ------- ----------

DEPT TABLE

EMP TABLE

BONUS TABLE

SALGRADE TABLE

TCUSTMER TABLE

TCUSTORD TABLE

6 rows selected.?

声明：
原创作品，出自 “深蓝的blog” 博客，允许转载，转载时请务必注明出处（http://blog.csdn.net/huangyanlong）。

关于涉及版权事宜，作者有权追究法律责任。