Database Administration (MOSC)

MOSC Banner

how to move lob column to different tablespace in a fast way?

edited Sep 26, 2017 5:01AM in Database Administration (MOSC) 11 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center