Explain Plan table

[BJCooperIT]

I have been tasked with running Explain Plans in a database where the EXPLAIN_PLAN table resides, but with a different table name (Thanks DBAs! ). Is there a way I can point the Explain Plan window to a different output table?

 

[hadfieldjohn]

Synonym?

 

[BJCooperIT]

Thanks, John. I would if I had the privileges in that database but, sadly, I am mostly a read-only user and the only table I can insert into is the dba's table dbasch.sqln_explain_plan. Just because they use a different tool than the developers, they think that table is sufficient. Grrr...

What I was hoping for is a preference for the Explain Plan table.

 

[Marco Kalter]

There is no preference. You will either need a synonym or create a PLAN_TABLE in your own schema.