ORA-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.
ORA-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.
ORA-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.
