Timeline for Why can I execute this query but not see its execution plan?
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 3, 2016 at 13:08 | comment | added | Marco |
I have always used the default table. Never this dbms_xplan.display. Do you have rights to this object (guess so since you say that other EXPLAIN PLAN statements work)? The error should not come from your select count(*) statement since all_tables only returns tables where you have access to (unless you lack the select privilege).
|
|
| Jun 3, 2016 at 12:46 | comment | added | Kshitiz Sharma |
Do you mean dbms_xplan.display? Apparently I have it already as other EXPLAIN statements are running just fine.
|
|
| Jun 3, 2016 at 12:38 | history | answered | Marco | CC BY-SA 3.0 |