SQL Developer explain plan broken

database oracle oracle-sqldeveloper sql-execution-plan
Barett picture Barett · Aug 6, 2010 · Viewed 7.7k times · Source

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?

Answer

Barett picture Barett · Aug 6, 2010

Execute this sql statement:

drop table plan_table

SQL Developer automatically regenerated the proper table & displayed the correct plan after pressing F6 again.

Related questions

How to enter special characters like "&" in oracle database?

I want to insert special character & in my insert statement. My insert is: INSERT INTO STUDENT(name, class_id) VALUES ('Samantha', 'Java_22 & Oracle_14'); If I try to run this query I am getting a popup and it …

Read More
Oracle TNS names not showing when adding new connection to SQL Developer

I'm trying to connect to an oracle database with SQL Developer. I've installed the .Net oracle drivers and placed the tnsnames.ora file at C:\Oracle\product\11.1.0\client_1\Network\Admin I'm using the following format in tnsnames.ora: dev = (DESCRIPTION = (…

Read More
Display all views on oracle database

Is there a way to display all the views currently set on an oracle database via sql developer? Thanks.

Read More