本帖最后由 zhenghaishu 于 2014-9-24 21:58 编辑
1 创建季度分区表
create table t(mydate varchar2(20), amount number) partition by range(mydate)
(
partition p20140101 values less than ('20140101') tablespace QUR_DT01,
partition p20140401 values less than ('20140401') tablespace QUR_DT02,
partition p20140701 values less than ('20140701') tablespace QUR_DT03,
partition p20141001 values less than ('20141001') tablespace QUR_DT04
);
验证:
SQL> SELECT tablespace_name,partition_name FROM dba_tab_partitions where table_name='T';
TABLESPACE_NAME PARTITION_NAME
------------------------------ ------------------------------
QUR_DT01 P20140101
QUR_DT02 P20140401
QUR_DT03 P20140701
QUR_DT04