Re: ORA-00604/ORA-16000 on standby

From: News <ben1245_111_at_hotmail.fr>
Date: Wed, 16 Jun 2010 04:24:25 -0700 (PDT)
Message-ID: <335f75b6-6350-4586-9c56-6550e1b41435_at_i28g2000yqa.googlegroups.com>

On 16 juin, 13:17, ddf <orat..._at_msn.com> wrote:
> If you actually login as this problem user do you still see the same
> errors?
>
> David Fitzjarrell

yes .. the code provided is a simulation

SQL> connect stymmz/stymmz_at_oragpd10
Connected.
SQL> select count(*) from historique_inventaire where 1=2; select count(*) from historique_inventaire where 1=2 *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database open for read-only access

SQL> select count(*) from oragp20c01.historique_inventaire where 1=2;

COUNT(*)

---

0 Received on Wed Jun 16 2010 - 06:24:25 CDT