ORA-00604/ORA-16000 on standby
Date: Wed, 16 Jun 2010 03:35:03 -0700 (PDT)
Message-ID: <2f60e2f5-5ceb-4b8e-94a1-5a45969753ed_at_x27g2000yqb.googlegroups.com>
Hi,
I have strange problem with one user that cannot query a table anymore. Th eproblem appeared suddenly while no change was made to primary. DB is running 10.2.0.2 on Solaris
SQL> alter session set current_schema=stymmz;
SQL> select count(*) from historique_inventaire where 1=2;
...
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
public synonym for table historique_inventaire is defined it works when schema is specified:
SQL> select count(*) from ORAGP20C01.HISTORIQUE_INVENTAIRE where 1=2;
COUNT(*)
0
it works with another user:
SQL> alter session set current_schema=SUPPORTDEV;
Session altered.
SQL> select count(*) from historique_inventaire where 1=2;
COUNT(*)
0
it works on primary .. Received on Wed Jun 16 2010 - 05:35:03 CDT