How to move table from one tablespace to another in oracle 11g

move, oracle, oracle11g

Solution

Try this:-

ALTER TABLE <TABLE NAME to be moved> MOVE TABLESPACE <destination TABLESPACE NAME>

Very nice suggestion from IVAN in comments so thought to add in my answer

Note: this will invalidate all table's indexes. So this command is usually followed by

alter index <owner>."<index_name>" rebuild;

Problem

I run `oracle 11g` and need to move `table (tbl1)` from one `tablespace (tblspc1)` to another `(tblspc2)`. What is the easiest way to do that?

Original source