3 Replies Latest reply: Feb 10, 2012 1:52 PM by Chami Herath RSS

SQL-Error 904 when doing SQL Explain in RSRT

Chami Herath
Currently Being Moderated

Hi all

 

I am trying to do a SQL explain in a query in RSRT to analyse why it is running so slow, but I keep getting an error message:

 

"An SQL-Error is occurred: 904".

 

I have tried using the "Display Run Schedule" option in RSRT. I have also tried "Display SQL/BIA Query" in RSRT and then hitting "Display of SQL Access Plan" but I get the same error message. I also get the same message when I try a SQL explain in ST05.

 

Does anyone have any ideas? System is a 701 SP5 and the DB is Oracle 10.2.0.4.0.

 

Regards

 

Chami

Actions