Re: how to explain plan to table other than plan_table?

Ben wrote:
> oracle ent ed, 9.2.0.5, dmts, compatible = 8.1.0 AIX5L
>
> How can you use explain plan with a plan table that is named something
> other than plan_table?

RENAME bad_table_name TO plan_table;

Or, if it present in 9.2.0.5, run $ORACLE_HOME/rdbms/admin/catplan.sql

and then drop the other table.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org