SQL & PL/SQL

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!

Able to execute a query in TOAD but can't ceate explain plan

user8941550Nov 29 2012 — edited Nov 29 2012

Hi,

I can execute a query in TOAD which uses table from other schema. I have created the synonym and given the rights on it.
But when I try to create explain plan using TOAD: I get Ora-00942:Table or view does not exist.
Any suggestions..

Thanks..

This post has been answered by BluShadow on Nov 29 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2012

Added on Nov 29 2012

7 comments

2,869 views