-- 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
/