how to move lob column to different tablespace in a fast way?
This database version is Oracle 12c. One table has one clob column which has size 60G.
I use this sql to get size:
SELECT SUM(DBMS_LOB.GETLENGTH(lob_column))/1024/1024 as total_MB
FROM table_name;
The I use this SQL to move this lob to different table space:
ALTER TABLE table_name MOVE LOB(lob_column) STORE AS (TABLESPACE tablespace_name);
The trouble is this alter ..move took 30 hours to finish.
My Question is: is there any way to make this move fast? 30 hours down time for production is too long.
Appreciate your help!
Thanks
Jin