Online redefinition of table with multiple CLOB columns not executing in parallel 19c
"Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -
Production Version 19.15.0.0.0"
The table with 3 CLOB columns is not executing in parallel during START_REDEF_TABLE stage of online redefinition. The source table is range partitioned using MAXVALUE and the destination table is range-interval partitioned.
The migration process is using DBMS_REDEFINITION and following parallel settings have been set at session level before executing the redefinition:
ALTER SESSION FORCE PARALLEL DML PARALLEL 8 ;
ALTER SESSION FORCE PARALLEL QUERY PARALLEL 8 ;
v$session parallel values mentioned below
PDML_STATUS: FORCED
PDDL_STATUS: ENABLED
PQ_STATUS: FORCED
If DBMS_REDEFINITION is executed with another table that contains 1 CLOB column, then parallelism works fine.