ALTER TABLE MOVE ONLINE

How to Resolve ORA-14133: ALTER TABLE MOVE cannot be combined with other operations

by Ed Chen
November 1, 2022October 17, 2022

ORA-14133 Tried to move a table to another tablespace, but it failed with ORA-14133. SQL> alter table employees move erp_tbs; alter table employees move erp_tbs… Read More »

Alter Table Move to Another Tablespace

by Ed Chen
December 8, 2021February 6, 2023

Move Table to Another Tablespace Basically, moving an Oracle table can defragment the data and make it compact so as to gain some benefit when… Read More »

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

by Ed Chen
December 6, 2021December 8, 2021

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)… Read More »