Originally posted by saneja
How hard is it to change a production dictionary managed tablespace into a locally managed tablespace ..Can this be done without exp/imp?
In resent Oracle versions you can use the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL() procedure to do this, or you could create a new set of tablespaces on your existing database and MOVE the tables/indexes. You don't necessarily need to create a new db.