Moving a regular table to a different tablespace is straight forward.
And then rebuild the indexes as it becomes invalid. But what if the table has LOB segments? Similar to INDEX, the LOB doesn’t moves where the table just relocated.
You can run the followings to see where it’s located. And take decision where do you want the LOB to move.
If you want to move only lob segment to a new tablespace then your command will be,
We can also move table and LOB altogether with the below command: