oracle SQL Developer 解释计划被破坏
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3426306/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL Developer explain plan broken
提问by Barett
Trying to generate an explain plan in SQL Developer, the program puts up a message box with title "failed to query plan_table" complaining "invalid column name". The plan is not generated or displayed. How to fix?
尝试在 SQL Developer 中生成解释计划时，程序会显示一个标题为“无法查询计划表”的消息框，并抱怨“列名无效”。不生成或显示计划。怎么修？
回答by Barett
Execute this sql statement:
执行这条sql语句：
drop table plan_table
SQL Developer automatically regenerated the proper table & displayed the correct plan after pressing F6 again.
再次按 F6 后，SQL Developer 会自动重新生成正确的表并显示正确的计划。
回答by Patrick Marchand
Normally PLAN_TABLE is a public synonym pointing to a table owned by SYS (e.g. SYS.PLAN_TABLE$ in 11g.)
通常 PLAN_TABLE 是指向 SYS 拥有的表的公共同义词（例如 11g 中的 SYS.PLAN_TABLE$。）
If you have recently upgraded the database, the plan_table is likely still "old" and needs to be upgraded (by the dba)
如果您最近升级了数据库，plan_table 可能仍然“旧”，需要升级（由 dba）
Each user should not have to worry about creating their own plan_table.
每个用户都不必担心创建自己的 plan_table。
