Skip to content

How to Resolve ORA-14808: table does not support ONLINE MOVE TABLE

  • by

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.

Leave a Reply

Your email address will not be published.