How To Move Table To Another Tablespace

 

In this article, I will show you how to move a table to another tablespace. Actually it is very simple to move table with just one command.

However, you must be careful on indexes and lobs.  All the indexes on the table will be invalidated because of table moving. So you must rebuild all indexes on the table.

If your table has lob columns, you must move them, too.

Onur Çınar
Author: Onur Çınar

Leave a Reply

Your email address will not be published. Required fields are marked *