原以为cluster表也是空,经测试发现不是。
SQL> create cluster clu_t (deptno number);
Cluster created.
SQL> create table t (id number,ename varchar2(20),deptno number) cluster clu_t (deptno);
Table created.
SQL> create global temporary table tt(id int);
Table created.
SQL> create table ttt(id int,name varchar2(20),job varchar2(20)) partition by range (job)
2(partition part1 values less than ('D'), partition part2 values less than (maxvalue));
Table created.
SQL> select table_name,tablespace_name,cluster_name from user_tables;
TABLE_NAME
TABLESPACE_NAME
CLUSTER_NAME
------------------------------ ------------------------------ ------------------------------
T
USERS
CLU_T
TT
TTT
SQL>
|