Monday , May 29 2023

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.


About Onur Çınar

Leave a Reply

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