I've set everything up so that Oracle automatically allocates space at the tablespace level:
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
I went ahead and created a table with no storage clause in one of these tablespaces, but when I look the the meta-data for the table thru OEM, I see the values for PCTFREE=10 & PCTUSED=0.
I thought that a tablespace in which the segments are set to have Oracle AUTOmatically allocate space, that bitmaps would control free space within segments, and that tables with no specific mention of PCTFREE and PCTUSED would inherit this property?
Can someone please help explain? PCTUSED=0 is unacceptable.