DBMS_REDEFINITION

Hello,

 Having a 510 Gig tablespace that has a table with a CLOB column , we need to reclaim space for rows that are no longer needed.

The below steps have been performed:

1.) I set the undo_retention to 1600000

alter system set undo_retention = 1600000;

2.) Increased the RBS tablespace which is UNDO

3.) Created a separte tablespace for the index

4.) Created a separate tablespace for the datafiles

5.) Set both tablespaces to no-logging

6.) Created the table:

CREATE TABLE "RADWARE"."REPORT_HISTORY_TEXT_2" NOLOGGING
TABLESPACE "DATA_HISTORIES_B" AS select report_history_rsn, report_text, report_history_text_seqno from report_history_text where 1=2;

CREATE UNIQUE INDEX "RADWARE"."PK_REPORT_HISTORY_TEXT_2"