on 02-10-2012 12:33 PM
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
Hi,
Check note
731 - Sammelhinweis: ORA-00904
specifically points 9 and 10 and make sure that your database is up
to the current patchset and SAP bundle patch and that the parameters
are setup correctly.
See notes
1175996 - Automated Oracle 10g/11g patches check
1171650 - Automated Oracle DB parameter check
Thanks,
Venkat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
plz see below thread:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.