ORA-31917
illegal operation on a table which has been locked by synchronous refresh
Cause
DML or DDL was used on a base table that had a staging log or 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 DML or DDL on such tables. You cannot modify tables locked by PREPARE_REFRESH until you have done the corresponding EXECUTE_REFRESH.
ORA-31917
illegal operation on a table which has been locked by synchronous refresh
Cause
DML or DDL was used on a base table that had a staging log or 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 DML or DDL on such tables. You cannot modify tables locked by PREPARE_REFRESH until you have done the corresponding EXECUTE_REFRESH.
ORA-31917
illegal operation on a table which has been locked by synchronous refresh
Cause
DML or DDL was used on a base table that had a staging log or 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 DML or DDL on such tables. You cannot modify tables locked by PREPARE_REFRESH until you have done the corresponding EXECUTE_REFRESH.
