Q
Problem solve Get help with specific problems with your technologies, process and projects.

No reduction in size of tablespace after moving schemas

I have moved indexes of a schema from one tablespace to another. But I don't see any reduction in size of the first tablespace where indexes were residing.

I have moved indexes of a schema from one tablespace to another. But I don't see any reduction in size of the first tablespace where indexes were residing. Can you please suggest something?
The tablespace will not be reduced in overall size. Oracle does not automatically deallocate space once it has been allocated. So when you moved the index to a new tablespace, the old tablespace remained the same size. However, the old tablespace has more free space in it now, which you can see in the DBA_FREE_SPACE view.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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