Need explain plan on standby read only databases
Hello,
The DEV team need to do explain plan on reporting database (read only standby or active dataguard).
I read than you can do explain plan on read only database with a dblink to primary database, but raise ORA-16000 errors.
primary:
create public database link "BATMAN" connect to system IDENTIFIED BY h5*** USING 'DBACAT_BATMAN_DIMADM01C1';
tnsnames on standby:
DBACAT_BATMAN_DIMADM01C1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = xxxxx)
)
)
1) without dblink:
SQL> explain plan for select 1 from dual;
explain plan for select 1 from dual
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
Tagged:
1