If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Extent Management

I migrated a database from 7 to 8 to 9i (9.2.0.6) and in 9i changed from Dictionary to Locally Managed tablespace. There are many objects which were created before we migrated to locally managed tablespace. Is there a way to find out which objects are still managed by dictionary.

My SYSTEM tablespace is still dictionary managed but ALL other are locally managed and I am looking for a way to find the objects which were created before the migration from dictionary to local so that I can rebuild them (alter table move...) in a newly created tablespace to have all the benefits of locally managed.