select 'drop materialized view log on '||mvl.log_owner||'.'||mvl.master||';' cmd from dba_mview_logs mvl where not exists ( select table_name from dba_tables tab where tab.owner = mvl.log_owner and tab.table_name = mvl.log_table ) ;
CMD
--------------------------------------------------------------------------------
drop materialized view log on SCOTT.EMP;
#执行正确的删除 materialized view log 语句
SQL> drop materialized view log on SCOTT.EMP;
Materialized view log dropped.
ORA-00942 when deleting from an existing Table after dropping materialized view log table (文档 ID 1912363.1)
CMD
--------------------------------------------------------------------------------
drop materialized view log on SCOTT.EMP;
#执行正确的删除 materialized view log 语句
SQL> drop materialized view log on SCOTT.EMP;
Materialized view log dropped.
ORA-00942 when deleting from an existing Table after dropping materialized view log table (文档 ID 1912363.1)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29487349/viewspace-2143798/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 【RESIZE】Oracle收缩表空间主要命令
- 【AUDIT]Oracle审计配置及常用sql
- 【MEMORY】Oracle内存结构资源常用视图及sql
- 【ORA-】ORA-12547: TNS:lost contact错误的跟踪分析
- 【NUMBER】Oracle数据库优化之理解NUMBER存储机制
- 【STAT】函数索引和使用表达式统计信息有什么不同
- 【SQL】Oracle数据库sql优化小技巧索引不管用怎么办01
- 【AWR】DBA_HIST视图查看存储在AWR中的历史数据
- 【SQL】Oracle 19c SQL隔离详解(SQL Quarantine)
- 【小惊喜】总算一个小惊喜，Oracle ACEA
