Tablespace Conversion

How to convert dictionary managed tablespace to locally managed tablespace?

Questions by raju4u

Showing Answers 1 - 3 of 3 Answers

mohibalvi

  • 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