Skip to Main Content
Forums

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!

PCTFREE/PCTUSED default setting?

Milan HrickoSep 17 2009 — edited Sep 19 2009
I tried to create table with PCTFREE=10, PCTUSED=70. But the table was created with PCTFREE=20 and value of PCTUSED is null (select on user_tables.pct_used).
I guess it must exists some default setting of these parameters (at tablespace level or global database level).
Where/How can I change it?

edit: Database 10g, 10.2.0.3

Edited by: user578314 on 17.9.2009 4:43
This post has been answered by Aman.... on Sep 17 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2009
Added on Sep 17 2009
#general-database-discussions
2 comments
1,889 views