Title: RE: Locally Managed Tablespace Confusion
I think it's because dba_segments (or dba_indexes) will show the initial/next specified at creation time, even though the extents were not created at that size. Look in dba_extents to see that all extents are the same size.
Example:
I am confused about locally managed tablespaces.
I created a locally managed tablespace called "INDEX01" using "UNIFORMED"
extents of 128K (131072bytes).
I then imported in the tables and indexes from an different database.
When I query DBA_TABLESPACES it shows that the tablespace has been create