I am currently having a setup of primary database along with a logical standby.i have certain MLOG$ tables in primary as well as logical standby but I don't need the MLOG$ tables in primary.So I thought of droping it but since dataguard is enable it will drop the tables from logical standby which I don't want.i want the tables to be dropped from primary database only.Do MLOG$ tables get replicated by SQL Apply process??..if yes then how can I Achieve my goal..kindly help me out.
Use dbms_logstdby.skip() to skip some statements on particular objects.
Good question. I believe MLOG$ can work independently because MLOG$ tables gets updated when their base table gets updated,so when your base table will be updated through log apply in standby , your mlog$ table should be updated. I am just saying on the basis of theory but you can test this. You can just drop the mlog$ in primary by using a SKIP procedure and see if your mlog$ in logical standby gets updated or not.