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!

Create tablespace and set default PCTFREE

348153Aug 26 2004 — edited Aug 30 2004

In a data warehouse, I would like to set the default pctfree to be 0 for all tables created in certain tablespaces. I found this old article on Metalink indicating this is possible:

When you create a table you can specify a value for pctfree. If you do not specify a value then the default pctfree for the tablespace will be used. If the tablespace was created without a pctfree value, then pctfree for the table you are creating will be 10 percent, the Oracle server default.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=135177.1

So now I want to create a tablespace that has the pctfree set to 0 but either this is no longer available (I'm using 9.2.0.5) or I have the syntax wrong.

Here is the test create statement I have. It throws " ORA-02143: invalid STORAGE option" when I set pctfree.

create tablespace test
datafile 'f:\oracle\oradata\test\test01.dbf' size 1m reuse
default storage(pctfree 0)
EXTENT MANAGEMENT LOCAL uniform size 40K
segment space management auto
nologging

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2004

Added on Aug 26 2004

#general-database-discussions

5 comments

1,816 views