Hi
i have a table of 9GB which contain the clob column ,
iam trying to do online partition, it is taking 2 days and it is still inprogress
ALTER TABLE x
PARTITION BY RANGE (CREATIONDATE)
INTERVAL(NUMTOYMINTERVAL(1,'MONTH'))
(
PARTITION p0_till_2018 VALUES LESS THAN (TO_DATE('01-01-2019', 'DD-MM-YYYY'))
)
UPDATE INDEXES
(schema.index1 GLOBAL,
schema.index2 GLOBAL,
schema.index3 GLOBAL
)
ONLINE;
can you tell me do we have any other option line increase memory or any lob parameter to be checked etc , anyother way to reduce the process hours or it is getting locked anywhere ?