Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

partitioned tables syntax - freelists etc

71610Oct 9 2009 — edited Oct 9 2009
The tablespaces are locally managed with segment space auto.

Create partition table in my schema is as below

create table table_name
(col1,
col2,
col3
constraint primary key(col1,col2) enable
) organization index compress 1 pctfree 10 inittrans 4 maxtrans 255
tablespace TSP1
storage(
freelists 20 buffer_pool default)
PCTTHRESHOLD 20 INCLUDING "VALUE" OVERFLOW
PCTFREE 10 INITRANS 1 MAXTRANS 255
TABLESPACE "TB01"
STORAGE(
BUFFER_POOL DEFAULT)
PARTITION BY RANGE ("col2")
(PARTITION "partition1" VALUES LESS THAN (1254403800001)
PCTFREE 10 INITRANS 4 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 20 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TB02"
OVERFLOW PCTFREE 10 PCTUSED 40 INITRANS 4 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 20 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TB02" ,
PARTITION "partitiont2" VALUES LESS THAN (1254405600001)
PCTFREE 10 INITRANS 4 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 20 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "PV01"
OVERFLOW PCTFREE 10 PCTUSED 40 INITRANS 4 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 20 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TB01"
....

Question
========
Should we be specifying initial,next,maxextents,freelists, freelist groups etc in the create table statement?
My understanding is we can refrain from mentioning these in the create statement and let oracle set it.

Thanks
San~
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2009
Added on Oct 9 2009
1 comment
661 views