dropping materialized view log
When I check on db01 - DBA_REGISTERED_MVIEWS, Mview in db02 still appears to be the registered mview although this db no longer exists. I think I should have manually issue drop materialized view in db02 before i totally remove it so that this site also unregistered itself in mater site - db01.
Since Mview in db02 still become registered mview in db01, i would need to manually unregister it and purge the log, and also dropping materialized view log, since the log are no longer needed anywhere.