I got three pairs of info about Initial and Next, and all of them are different:
(1). Initial_Extent/Next_Extent in USER_TABLES
(2). Initial/Next in the .dmp file, compress=n
(3). Initial/Next in the .dmp file, compress=y
I thought that (1) and (2) should be the same and both represent the most update setting of the tablespace. However, in some of my tables, the NEXT_EXTENT in (1) and the NEXT in (2) are different. Why?
In some of my tables, The NEXT in (2) and (3) are also different. Why? Because PCTINCREASE is NOT equal to 0?
Thanks a lot!!