SQL Developer

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!

Choose specific plan_table in SQL Developer 2+?

cjonesMay 11 2011 — edited May 20 2011

My company is running on an older of Oracle, so we don't have the much 'friendlier' plan_table system that is currently being used.

I have a plan_table created for my specific connection/login, but it appears that SQL Developer is looking for the SYS based plan_table found in later versions of Oracle.

Is there any way, in SQL Developer, that I can make it use my own plan_table for Explain Plans? I have looked through preferences, but I can't find anything that would let me do it. My colleagues that are using TOAD said that they were prompted to choose a plan_table. I prefer SQL Developer, but will be forced to go to TOAD if I can get explain plans working.

Thanks ahead of time...

CJ

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2011

Added on May 11 2011

#sql-developer, #sqldeveloper

9 comments

657 views