RE: Locally Managed Tablespace Confusion

2002-02-06 Thread Jacques Kilchoer
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:

Locally Managed Tablespace Confusion

2002-02-06 Thread Pat Howe
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