Right command to move a LOB to another Tablespace
A LOB with simple column name can be moved to a different tablespace using the following command.
alter table "OWNER"."TABLE_NAME" move lob("COLUMN_NAME") STORE AS (TABLESPACE "NEW_TBS");
However, we've some LOBs with COLUMN_NAMEs as listed below.
"USER_DATA"."PARAMETER_LIST"
"USER_DATA"."HEADER"."PROPERTIES"
"USER_DATA"."TEXT_LOB"
How can we move LOBs with such COLUMN_NAMEs?
Thanks,
Kashif.