How To Move Lob Data in a Table To Another Tablespace

dbtut

5 years ago

In some cases, we may need to move the lob columns in a table to another tablespace.

You can do this with the following command online:

alter table USER.TABLE move lob (LOB_COLUMN_NAME) store as (tablespace NEW_TABLESPACE);

1	alter table USER.TABLE move lob (LOB_COLUMN_NAME) store as (tablespace NEW_TABLESPACE);

After Move, the data in the lob column of the table will be moved to the new tablespace. Other data of the table will be kept in the tablespace of the table. We’re just gonna move the lob data.