Alter Table Move to Another Tablespace
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 »Alter Table Move to Another Tablespace
ALTER TABLE MOVE ONLINE
How to Resolve ORA-14808: table does not support ONLINE MOVE TABLE
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 »How to Resolve ORA-14808: table does not support ONLINE MOVE TABLE