We have upgraded our db from 9.2.0.8 to 11.2.04 and whilst trying to run the following statement, I am getting the error : ORA-32417: must use DROP MATERIALIZED VIEW LOG to drop "PSCRIS"."MLOG$_PS_BC".
drop table PSCRIS.MLOG$_PS_BC;
This statement works fine 9.2.0.8 without any issue, but getting the above message in 11.2.0.4
As per above message, changed the statement to "DROP MATERIALIZED VIEW LOG ON PSCRIS.MLOG$_PS_BC;" but getting ORA-12002: there is no materialized view log on table "PSCRIS"."MLOG$_PS_BC".
How do I fix this?