Re: ORA-00604/ORA-16000 on standby

From: News <ben1245_111_at_hotmail.fr>
Date: Wed, 16 Jun 2010 04:52:09 -0700 (PDT)
Message-ID: <1bb91173-a9ca-4887-bf90-ad3a5a932478_at_h13g2000yqm.googlegroups.com>

On 16 juin, 12:35, News <ben1245_..._at_hotmail.fr> wrote:
> 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 ..

the problem was related to invalid private synonyms Received on Wed Jun 16 2010 - 06:52:09 CDT