ORA-12096: error in materialized view log on "SYSADM"."ABC ORA-00942: table or view does not exist
On 22nd Oct, a table MLOG$_ABC got created b'coz, I might have executed DBMS_REDEFINITION(SYSADM, ABC) and which we want to get rid off now.
We want to get rid of MLOG$_ABC, When I DROP TABLE MLOG$_ABC; all the process (UPDATE or INSERT on table ABC) getting cancelled with the error below
ORA-12096: error in materialized view log on "SYSADM"."ABC ORA-00942: table or view does not exist
We want to get rid of MLOG$_ABC, When I DROP TABLE MLOG$_ABC; all the process (UPDATE or INSERT on table ABC) getting cancelled with the error below
ORA-12096: error in materialized view log on "SYSADM"."ABC ORA-00942: table or view does not exist
0