initial extent size of tablespaces
i created two tablespaces using the default storage clause .
one had initital size as 20k , next as 20k , pctincrease as 0, blocksize as 4k.
second had initital size as 20k , next as 20k , pctincrease as 50, blocksize as 4k.
when i queried dba_tablespaces , it changed(reduced) the initial size and pctincrease column was blank for the second tablespace.
why does it change
Did you read the answers to your earlier posted thread ??
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
"There is a difference between knowing the path and walking the path."
Click Here to Expand Forum to Full Width