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!

FREELISTS and FREELIST GROUPS of CREATE TABLE

user1095915Feb 9 2016 — edited Feb 10 2016

My oracle is 10g, create table statement is below:

CREATE TABLE S005.Test

(

  aaa  CHAR(1)

)

PCTFREE    0

STORAGE    (

            FREELISTS        10

            FREELIST GROUPS  20

           )

LOGGING

NOCACHE

NOPARALLEL

NOMONITORING;

After execute this sql, i query USER_TABLES table but FREELISTS and FREELIST_GROUPS fields show nothing,

I think value of FREELISTS should be 10, and FREELIST_GROUPS should be 20. How to retrieve these values?

Thanks a lot

This post has been answered by jgarry on Feb 10 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2016
Added on Feb 9 2016
6 comments
1,558 views