测试环境:oracle Release 10.2.0.1.0 , 建分区数据oracle_sid=ascii , 无分区数据库oracle_sid=ocp10g
1.在ascii数据库中建立3个tablespaces:tbs1,tbs2,tbs3;
SQL> create tablespace tbs1 datafile 'tbs1_data1' size 10M;
Tablespace created.
SQL> create tablespace tbs2 datafile 'tbs2_data1' size 10M;
Tablespace created.
SQL> create tablespace tbs3 datafile 'tbs3_data1' size 10M;
Tablespace created.
2.建立分区数据库表tbs_t:
SQL> create table tbs_t(a int ) partition by range(a)
2 (
3 partition tbs1 values less than (100),
4 partition tbs2 values less than (200),
5 partition tbs3 values less than (maxvalue));Table created.
3.在tbs_t中插入数据commit后数据:
SQL> select * from tbs_t;
A
----------
1