Suppose, we are creating one table. at that time we are
mention table space and size category.
Generally size category is from 0 to 6 is available. suppose
if we are declare size category as 0(zero).
For 0 (zero) the size of rows is from 0(zero) to 19000. I
have 25000 records to insert into table. but table size is
declared as 0(zero). i.e 19000 records. what about remaining
6000 records. shall i insert in to table or not?
if insert how can i do? if not insert what can i do? Please
answer me? i faced this one in TCS interview.
It will create another extent . suppose the primary extent
contain the 19000 record and the next extent or secondary
extent contain the remaining 6000 record . Its created
automatecally by the RDMS. ok