Tbs READ ONLY and Snapshot too old 2004-06-17 - By Bobak, Mark
Actually, you can get an ORA-1555 (See ORA-1555.ora-code.com) 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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Justin Cave
Sent: Friday, June 11, 2004 6:15 AM
To: oracle-l@(protected)
Subject: RE: Tbs READ ONLY and Snapshot too old
ORA-01555 (See ORA-01555.ora-code.com) 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 (See ORA-01555.ora-code.com) error when trying
to access a read-only object.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD > <TITLE >Message </TITLE >
<META http-equiv=Content-Type content= "text/html; charset=us-ascii " >
<META content= "MSHTML 6.00.2713.1100 " name=GENERATOR > </HEAD >
<BODY >
<DIV > <SPAN class=378121716-17062004 > <FONT face=Arial color=#0000ff
size=2 >Actually, you can get an ORA-1555 (See ORA-1555.ora-code.com) on an object in a read only tablespace,
believe it or not: </FONT > </SPAN > </DIV >
<DIV > <SPAN class=378121716-17062004 > <FONT face=Arial color=#0000ff size=2 > <A
href= "http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:895410916429 " >http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:895410916429 </A > </FONT > </SPAN > </DIV >
<DIV > <SPAN class=378121716-17062004 > <FONT face=Arial color=#0000ff
size=2 > </FONT > </SPAN > </DIV >
<DIV > <SPAN class=378121716-17062004 > <FONT face=Arial color=#0000ff
size=2 >-Mark </FONT > </SPAN > </DIV >
<DIV > <FONT face=Arial color=#0000ff size=2 > </FONT > </DIV >
<DIV > <FONT face=Arial color=#0000ff size=2 > </FONT > </DIV >
<P > <FONT face= "Comic Sans MS " color=#008000 size=2 >Mark J. Bobak </FONT >
<BR > <FONT face= "Comic Sans MS " color=#008000 size=2 >Oracle DBA </FONT > <BR > <FONT
face= "Comic Sans MS " color=#008000 size=2 >ProQuest Company </FONT > <BR > <FONT
face= "Comic Sans MS " color=#008000 size=2 >Ann Arbor, MI </FONT > <BR > <B > <FONT
face=Arial size=2 > "Post Hoc Ergo Propter Hoc " </FONT > </B > </P >
<BLOCKQUOTE dir=ltr style= "MARGIN-RIGHT: 0px " >
<DIV > </DIV >
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left > <FONT
face=Tahoma size=2 >-- --Original Message-- -- <BR > <B >From: </B >
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <B >On
Behalf Of </B >Justin Cave <BR > <B >Sent: </B > Friday, June 11, 2004 6:15
AM <BR > <B >To: </B > oracle-l@(protected) <BR > <B >Subject: </B > RE: Tbs READ ONLY
and Snapshot too old <BR > <BR > </FONT > </DIV >
<DIV dir=ltr align=left > <FONT face=Arial color=#0000ff size=2 > <SPAN
class=359271110-11062004 >ORA-01555 (See ORA-01555.ora-code.com) 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 (See ORA-01555.ora-code.com) error when
trying to access a read-only object. </SPAN > </FONT > </DIV >
<DIV dir=ltr align=left > <FONT face=Arial color=#0000ff size=2 > <SPAN
class=359271110-11062004 > </SPAN > </FONT > </DIV >
<DIV dir=ltr align=left > </DIV > </BLOCKQUOTE > </BODY > </HTML >
|
|
