ALTER TABLE MOVE ONLINE

How to Resolve ORA-25182: feature not currently available for index-organized tables

by Ed Chen
October 5, 2023September 7, 2023

ORA-25182 Found ORA-25182 when I tried to move an index-organized table to another tablespace. SQL> ALTER TABLE ERPAPP.CONFIG MOVE TABLESPACE ERP_TBS_01 ONLINE PARALLEL 16; ALTER… Read More »

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, 2021March 23, 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 »

JavaScript is not enabled. Please enable it and reload the page.