I have a question on explain plans:
I have a table MY_TABLE on which versioning is enabled:
If I want to get an explain plan for a query on this versioned table like "select * from MY_TABLE",
I get an ORACLE error: "ORA-0109: insufficient privileges on underlying objects of the view"
If I am trying to obtain the explain plan for "SELECT * FROM MY_TABLE_LT", there is no problem at all.
What are the privileges I need to get explain plans for queries on versioned tables?
Edited by: 938444 on 04-jun-2012 4:37
I just found the solution myself.
The view MY_TABLE (when the table is versioned) needs SELECT privileges on the following tables:
In my case, the grant on wmsys.wm$modified_tables was missing:
grant select on wmsys.wm$modified_tables to <schema>
Thanks to everyone,