ORA-12842: Cursor invalidated during parallel execution error during alter table move subpartition

2.3k Views Asked by At

Had a task to compress some large tables to reduce storage costs by using Oracle's Advanced Compression. Here is the statement :

execute immediate 'ALTER TABLE ' || i_table_name || ' 
                          MOVE SUBPARTITION '|| i_sub_part_name || ' ONLINE 
                          ROW STORE COMPRESS ADVANCED 
                          UPDATE INDEXES NOLOGGING '

This statement is called by 15-20 independent jobs each with their own subpartition name. For most of the time, we get no error for majority of subpartitions, but in each run there are 1-2 cases where ORA-12842 error is thrown. There is no parallal hint, or alter session command for parallel execution, no indexes are being dropped during execution nor another session changing the same subpartition.

Any other reason why this could happen?

0

There are 0 best solutions below