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