When I have a tablespace that is Dictionary Managed, I do not convert it to a LMT. Instead, I create a new LMT tablespace and move segments into this new tablespace. Tables are moved with the ALTER TABLE MOVE command and indexes are moved with the ALTER INDEX REBUILD command. Once the old DMT tablespace is empty, it can be dropped.
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.