Tablespace Conversion

How to convert dictionary managed tablespace to locally managed tablespace?

Questions by raju4u

Showing Answers 1 - 1 of 1 Answers


  • Mar 13th, 2009

You can use DBMS_SPACE_ADMIN package to convert DMT to LMT. 

exec dbms_space_admin.Tablespace_Migrate_TO_Local('ts_dm');

where ts_dm is the name of tablespace that need to be converted to locally managed tablespace.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions