ORA-14808
Saw error ORA-14808 when we tried to move a Large Object (LOB) column to another tablespace online.
SQL> alter table PM.PRINT_MEDIA move online lob(AD_PHOTO) store as (tablespace USERS);
alter table PM.PRINT_MEDIA move online lob(AD_PHOTO) store as (tablespace USERS)
*
ERROR at line 1:
ORA-14808: table does not support ONLINE MOVE TABLE
Even though I change the position of ONLINE clause to the last of the statement, it still failed.
SQL> alter table PM.PRINT_MEDIA move lob(AD_PHOTO) store as (tablespace USERS) online;
alter table PM.PRINT_MEDIA move lob(AD_PHOTO) store as (tablespace USERS) online
*
ERROR at line 1:
ORA-14808: table does not support ONLINE MOVE TABLE
ORA-14808 means that we can't perform such operations on this table online. Which means, we can't move LOB column online. Finally, I gave up the idea of moving the LOB column to another tablespace online.