--oracle表分区脚本备忘
CREATE TABLE t_partition_exam
(
STATDATE CHAR(8 BYTE) NOT NULL,
...,
ACCOUNT_ITEM VARCHAR2(14 BYTE) NOT NULL
)
TABLESPACE ZHJSFX_USER
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
NOLOGGING
PARTITION BY RANGE (STATDATE)
(
PARTITION P200501 VALUES LESS THAN ('20050201')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200502 VALUES LESS THAN ('20050301')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200503 VALUES LESS THAN ('20050401')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200504 VALUES LESS THAN ('20050501')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200505 VALUES LESS THAN ('20050601')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200506 VALUES LESS THAN ('20050701')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200507 VALUES LESS THAN ('20050801')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200508 VALUES LESS THAN ('20050901')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200509 VALUES LESS THAN ('20051001')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200510 VALUES LESS THAN ('20051101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200511 VALUES LESS THAN ('20051201')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200512 VALUES LESS THAN ('20060101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200601 VALUES LESS THAN ('20060201')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200602 VALUES LESS THAN ('20060301')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200603 VALUES LESS THAN ('20060401')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200604 VALUES LESS THAN ('20060501')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200605 VALUES LESS THAN ('20060601')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200606 VALUES LESS THAN ('20060701')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200607 VALUES LESS THAN ('20060801')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200608 VALUES LESS THAN ('20060901')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200609 VALUES LESS THAN ('20061001')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200610 VALUES LESS THAN ('20061101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200611 VALUES LESS THAN ('20061201')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200612 VALUES LESS THAN ('20070101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200701 VALUES LESS THAN ('20070201')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200702 VALUES LESS THAN ('20070301')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200703 VALUES LESS THAN ('20070401')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200704 VALUES LESS THAN ('20070501')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200705 VALUES LESS THAN ('20070601')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200706 VALUES LESS THAN ('20070701')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200707 VALUES LESS THAN ('20070801')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200708 VALUES LESS THAN ('20070901')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200709 VALUES LESS THAN ('20071001')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200710 VALUES LESS THAN ('20071101')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200711 VALUES LESS THAN ('20071201')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200712 VALUES LESS THAN ('20080101')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200801 VALUES LESS THAN ('20080201')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200802 VALUES LESS THAN ('20080301')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200803 VALUES LESS THAN ('20080401')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200804 VALUES LESS THAN ('20080501')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200805 VALUES LESS THAN ('20080601')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200806 VALUES LESS THAN ('20080701')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200807 VALUES LESS THAN ('20080801')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200808 VALUES LESS THAN ('20080901')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200809 VALUES LESS THAN ('20081001')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200810 VALUES LESS THAN ('20081101')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200811 VALUES LESS THAN ('20081201')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200812 VALUES LESS THAN ('20090101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200901 VALUES LESS THAN ('20090201')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200902 VALUES LESS THAN ('20090301')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200903 VALUES LESS THAN ('20090401')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200904 VALUES LESS THAN ('20090501')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200905 VALUES LESS THAN ('20090601')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200906 VALUES LESS THAN ('20090701')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200907 VALUES LESS THAN ('20090801')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200908 VALUES LESS THAN ('20090901')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200909 VALUES LESS THAN ('20091001')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200910 VALUES LESS THAN ('20091101')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200911 VALUES LESS THAN ('20091201')
NOLOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
),
PARTITION P200912 VALUES LESS THAN ('20100101')
LOGGING
NOCOMPRESS
TABLESPACE ZHJSFX_FACT_WJJS
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
)
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;
--操作表分区
--操作某个分区,如一分区t_partition_exam partition (p1)
select * from t_partition_exam partition (p1);
--只要知道了如何访问表分区,其它一切OK