Ignore RE: Weird read-only error Solaris 10,

From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Wed, 7 Oct 2009 10:37:47 -0500
Message-ID: <565F609E6D736D439837F1A1A797F341020CCDDA_at_ADMINMAIL1.ui.uillinois.edu>

Synonym went invalid for some reason. Good to go now.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Newman, Christopher Sent: Wednesday, October 07, 2009 10:32 AM To: oracle-l_at_freelists.org
Subject: Weird read-only error Solaris 10,  

We have a daily clone that we open in read-only mode. User reports the following error:

select * from t_sap_cd

ORA-00604: error occurred at recursive SQL level 1

ORA-16000: database open for read-only access

When fully qualifying the table name, ie sales.t_sap_cd, the query works. I've checked the synonyms and they look to be OK. The only clue here is that there was DDL executed against the primary last night before the clone was created. Other tables in the same schema can be queried without fully qualifying without issue. Anyone see this behavior before?

Thanks- Chris

Received on Wed Oct 07 2009 - 10:37:47 CDT

Original text of this message