ORA-22905 cannot access rows from a non-nested table item
As discussed in another one of my articles on explain plans, there are many ways to generate them and they are a vital part of your SQL Tuning tool kit. So, what happens when you get an error such as the one below?
SELECT * FROM TABLE(dbms_xplan.display(‘PLAN_TABLE’,’test’,’ALL’))
*
ERROR at line 1:
ORA-22905: cannot access rows from a non-nested table item
It’s a simple fix; you can use the SQL below to get the explain plan from the plan table:
SELECT *
FROM TABLE(dbms_xplan.display(‘PLAN_TABLE’,’test’, ‘ALL’));
Like it, share it...
Category: SQL Tuning
Comments (2)
Trackback URL | Comments RSS Feed