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/02/21 19:09 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki