Pages

Tuesday, 9 December 2014

oracle 11g - explain plan gives 'PLAN_TABLE' is old version

Experiencing as old plan table during explain plan of query.

explain plan for
select .....
/
@?/rdbms/admin/utxlpls

getting below issue as

 'PLAN_TABLE' is old version

Solution:

conn /as sysdba
drop table plan_table;
drop table plan_table$;
@?/rdbms/admin/catplan.sql

No comments:

Post a Comment