Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to use EXPLAIN PLAN in Toad

450433Aug 29 2006 — edited Aug 29 2006
hi,
I am not able to use Explain Plan in Toad. The error it gives is the table PLAN_TABLE doesn't exit.
But after seeing this error I did run the script "UTLXPLAN.sql" in order to create the plan_table table.
After installing the above table I am not able to use EXPLAIN_PLAN from toad, Its giving same error Table PLAN_TABLE doesn't exit though i created it successfully in the proper schema.


Thanks in advance
Ram
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2006
Added on Aug 29 2006
3 comments
519 views