drop Materialized view log msis_dim.msm_age_grp;
drop Materialized view log msis_dim.msm_age_grp
ERROR at line 1:
ORA-00969: missing ON keyword
I attempted to create am MV. It failed but before then my script had already created the MV log. Now I want to drop the MV log but it won't work. What is missing here?
NB the MV has not been created yet.