ALTER TABLE MOVE TABLESPACE

How to Resolve ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

by Ed Chen
March 6, 2023March 7, 2023

ORA-00054 There're several cases that throw ORA-00054. Alter Table Move Tablespace We tried to move table to another tablespace. SQL> show user USER is "HR"… Read More »

How to Resolve ORA-01647: tablespace is read-only, cannot allocate space in it

by Ed Chen
February 3, 2023January 5, 2023

ORA-01647 Tried to move a table to another tablespace, but it failed with ORA-01647. SQL> alter table employees move tablespace example; alter table employees move… 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 »

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