Q
Manage Learn to apply best practices and optimize your operations.

Switching to auto space management

I am operating Oracle 10g. Some of my tablespaces are on manual space management. I want to migrate segment space management from manual to auto.

I am operating Oracle 10g. Some of my tablespaces are on manual space management. I want to migrate segment space management from manual to auto.
According to the Oracle docs, "You cannot change the segment space management mode of a tablespace." This means that your only option is to create a new tablespace that does use Automatic Segment Space Management (ASSM) and then move your objects into the new tablespace. You can use Data Pump for this move. But an easier way to move tables and indexes is with the ALTER TABLE MOVE command or the ALTER INDEX REBUILD command.

 

Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close