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