SQL> create table test(id int primary key,b varchar2(2));
Table created.
oracle会在id上创建一个唯一索引,索引名由系统指定,索引和表的表空间在同一个表空间。
SQL> select index_name,index_type,table_name,tablespace_name from user_indexes where table_name='TEST';
INDEX_NAME INDEX_TYPE TABLE_NAME TABLESPACE_NAME
------------------------------ --------------------------- ------------------------------ --------------------------
SYS_C006680 NORMAL TEST USERS
SQL> select table_name,tablespace_name from user_tables where table_name='TEST';
TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TEST USERS
现在为了把索引表空间和表的表空间分开,可以在创建表的时候使用using index
SQL> create table test (id int,b varchar2(2),
2 constraint pk_id primary key(id) using index tablespace idx);
Table created.
SQL> select index_name,index_type,table_name,tablespace_name from user_indexes where table_name='TEST';
INDEX_NAME INDEX_TYPE TABLE_NAME TABLESPACE_NAME
------------------------------ --------------------------- ------------------------------ ------------------------
PK_ID NORMAL TEST IDX
SQL> select table_name,tablespace_name from user_tables where table_name='TEST';
TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TEST USERS
Table created.
oracle会在id上创建一个唯一索引,索引名由系统指定,索引和表的表空间在同一个表空间。
SQL> select index_name,index_type,table_name,tablespace_name from user_indexes where table_name='TEST';
INDEX_NAME INDEX_TYPE TABLE_NAME TABLESPACE_NAME
------------------------------ --------------------------- ------------------------------ --------------------------
SYS_C006680 NORMAL TEST USERS
SQL> select table_name,tablespace_name from user_tables where table_name='TEST';
TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TEST USERS
现在为了把索引表空间和表的表空间分开,可以在创建表的时候使用using index
SQL> create table test (id int,b varchar2(2),
2 constraint pk_id primary key(id) using index tablespace idx);
Table created.
SQL> select index_name,index_type,table_name,tablespace_name from user_indexes where table_name='TEST';
INDEX_NAME INDEX_TYPE TABLE_NAME TABLESPACE_NAME
------------------------------ --------------------------- ------------------------------ ------------------------
PK_ID NORMAL TEST IDX
SQL> select table_name,tablespace_name from user_tables where table_name='TEST';
TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TEST USERS
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26937943/viewspace-1144655/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26937943/viewspace-1144655/