Migrate Tablespace from dictionary managed to Locally Managed -- 10g
Kevin_KMay 14 2009 — edited May 14 2009Is there any document which specifies the best practice to migrate the tablespace from dictionary managed extent management to locally managed with automatic segment space management.
I read that we can migrate using the DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL procedure , but this is not very clean because the existing data will still be using the dictionary managed and newly inserted rows will follow the local space management, is this correct?
Can someone please provide some input?
Thank You
Kev