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