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
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