Explain tables does not exist. Check the explain plan properties for this database connection.
来源:互联网 发布:工业控制网络标准协议 编辑:程序博客网 时间:2024/05/21 14:05
使用DbVisulalizer链接db2,查看执行计划是报错误
Explain tables does not exist. Check the explain plan properties for this database connection.
就是执行计划的表不村子,检查执行计划属性。
查看连接属性如下
只有DB2LUW里面才有Explain Plan属性,所以先调整Connection属性中的datatype,为DB2 LUW:
然后再用,发现还是一样的错误,最后仔细看,才发现有个勾没有勾上
只有勾上了create plan table if not exists,就是如果计划表不存在就创建。然后解决问题。
当然我们也可以把下面的Drop Explain Plan Table在执行完成后删除对应的信息。
1 0
- Explain tables does not exist. Check the explain plan properties for this database connection.
- The connection does not exist.
- EXPLAIN PLAN FOR
- This network connection does not exist
- Explain plan
- Explain Plan
- explain plan
- Explain Plan
- explain plan
- ORA-20200: End Snapshot Id 2 does not exist for this database/instance
- explain the HttpURLConnection connection process
- Explain plan for last executed statement
- Oracle 执行计划 Explain plan for
- oracle explain plan for的用法
- HOw to see the oracle explain plan
- This File Does Not Exist At The Requested Revision
- The file does not exist for the external tool
- Explain Plan 使用
- JS代码网
- Android如何使用API
- Java线程(十):CyclicBarrier-用路障实现分阶段线程并发
- 初学MongoDB(三)——c++ (java)接口
- 求1-10000之间的同构数
- Explain tables does not exist. Check the explain plan properties for this database connection.
- CSU 1333: Funny Car Racing 最短路
- javascript学习笔记
- 八
- UIImageView 的contentMode属性应用
- Binder机制1---Binder原理介绍
- mootools使用ajax返回json格式的代码
- 第三部分:ORACLE 12C中部署BIEE 11G 之RCU的安装
- actionSheetView