969257 wrote:I haven't tersted this (I don't have a suitable environment to hand) but how about this:
How can we execute explain plan for queries connecting to Physical standby database over DB link.
explain plan for select * from test.test_table@stby;
Getting ORA-16000 when trying to that.
Tried to set transaction to read only.
Then tried to run explain plan, that gives error for ora-02047 cannot join the distributed
Any insight will be appreciated.