Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-31930

The table is locked by synchronous refresh and the requested operation cannot be performed.

Cause

An attempt was made to perform a PMOP (partition maintenance operation) or otherwise modify a table that was locked by synchronous refresh. The synchronous refresh operation locks tables related to the refresh group at PREPARE_REFRESH time and unlocks them after the EXECUTE_REFRESH is done to prevent wrong results.


Action

Do not perform PMOPs or modify the table between the execution of PREPARE_REFRESH and EXECUTE_REFRESH. You can do these operations before PREPARE_REFRESH or after EXECUTE_REFRESH.