Explain plan HTML, XML, Text error ORA-00904

ariffe

Member
When selecting the HTML, Text, and XML tabs in the explain plan window I am getting an error and no output:

ORA-00904: "OTHER_XML": invalid identifier

We are on DB v 11.2.0.3 and I can see column OTHER_XML in view gv$sql_plan (which I assume this window is using).

Is there a profile I need to set?

Thanks,
Greg
 
This indicates an outdated plan_table. You will need to drop it and recreate it from an up-to-date script.
 
Back
Top