-- drop materialized view logs from dev/test database SELECT * FROM DBA_MVIEW_LOGS / DROP MATERIALIZED VIEW LOG ON SYSADM.PS_PAYGROUP_TBL / DROP MATERIALIZED VIEW LOG ON SYSADM.PS_PAY_CALENDAR / DROP MATERIALIZED VIEW LOG ON SYSADM.PS_PAY_EARNINGS / DROP MATERIALIZED VIEW LOG ON SYSADM.PS_PAY_OTH_EARNS / SELECT * FROM DBA_MVIEW_LOGS / COMMIT /