User Tools

Site Tools


tech:psoft:rm_materialized_views

Drop Materialized View Logs

Drop materialized view logs for Nextel dev/test databases.

8
-- 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
/
tech/psoft/rm_materialized_views.txt · Last modified: 2024/06/21 12:04 by 127.0.0.1