RE: Tbs READ ONLY and Snapshot too old

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 17 Jun 2004 12:17:58 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B455BE@bosmail00.bos.il.pqe>

Actually, you can get an ORA-1555 on an object in a read only tablespace, believe it or not:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:89541 0916429  

-Mark
   

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Justin Cave
	Sent: Friday, June 11, 2004 6:15 AM
	To: oracle-l_at_freelists.org
	Subject: RE: Tbs READ ONLY and Snapshot too old
	
	
	ORA-01555 indicates that Oracle was attempting to reconstruct

the state of a block and the earlier state was not available in the undo segments. By definition, you cannot get an ORA-01555 error when trying to access a read-only object.                    

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jun 17 2004 - 11:15:00 CDT