0922-2

create tablespace ps

datafile 'H:\oracle\product\10.2.0\oradata\orcl\ps.dbf' size 50M;

创建表分区

CREATE TABLE aa 
(user_id number(20) primary key,
user_name   varchar2(100) not null,
regist_time varchar2(200) not null
)
partition by range(regist_time)
(
    partition part_01 values less than(to_date('2003-01-01','yyyy-mm-dd') ) tablespace USERS,


    partition part_02 values less than(to_date('2006-01-01','yyyy-mm-dd') ) tablespace USERS


);