--0.版本及环境
SQL> conn / as sysdba
已连接。
SQL> create tablespace tp_p1 datafile 'd:/oracle/oradata/test/tp_p1.dbf' size 10m
2 autoextend on next 1m maxsize 100m
3 extent management local
4 segment space management auto;
表空间已创建。
SQL> create tablespace tp_p2 datafile 'd:/oracle/oradata/test/tp_p2.dbf' size 10m
2 autoextend on next 1m maxsize 100m
3 extent management local
4 segment space management auto;
表空间已创建。
SQL> select * from v$version;
BANNER
----------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
----------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
SQL> conn test/test
已连接。
SQL> show userUSER 为"TEST"
SQL> select USERNAME, DEFAULT_TABLESPACE from user_users where username='TEST';
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
TEST TP_TEST
------------------------------ ------------------------------
TEST TP_TEST
--1.表不指定表空间,则为用户默认表空间;分区不指定表空间,则默认为表所在的表空间
SQL> create table testrp(a number(10), b varchar2(10))
2 partition by range(a)(
3 partition testrp1 values less than (51),
4 partition testrp2 values less than (maxvalue)
5 );
SQL> create table testrp(a number(10), b varchar2(10))
2 partition by range(a)(
3 partition testrp1 values less than (51),
4 partition testrp2 values less than (maxvalue)
5 );
表已创建。
SQL> select SEGMENT_NAME, PARTITION_NAME, SEGMENT_TYPE, TABLESPACE_NAME
2 from user_segments where segment_name = 'TESTRP';
2 from user_segments where segment_name = 'TESTRP';
SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE TABLESPACE_NAME
------------- ------------------------------ ------------------ --------
TESTRP TESTRP1 TABLE PARTITION TP_TEST
TESTRP TESTRP2 TABLE PARTITION TP_TEST
------------- ------------------------------ ------------------ --------
TESTRP TESTRP1 TABLE PARTITION TP_TEST
TESTRP TESTRP2 TABLE PARTITION TP_TEST
--2.表可以指定自己的表空间,分区仍是表所在的表空间