Re: ORACLE error 1555 encountered

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Tue, 8 Jan 2013 07:34:16 -0800 (PST)
Message-ID: <1357659256.42768.YahooMailNeo_at_web121604.mail.ne1.yahoo.com>

Resizing the UNDO tablespace won't help the LOB situation, which is where I believe your ORA-01555s are originating.  I've written on this some time ago here: http://dfitzjarrell.wordpress.com/2008/02/22/the-dreaded-ora-01555/  
This may help explain what is happening and how you might avoid the ORA-01555 issue.  Also, have you checked Metalink for any bugs that could generate those errors? David Fitzjarrell

---

From: carlos castro <ccastro7145_at_gmail.com> To: oracle-l_at_freelists.org
Sent: Tuesday, January 8, 2013 2:00 AM
Subject: ORACLE error 1555 encountered

Hello,
I currently  have a problem with my Oracle Database 10g Release 10.2.0.5.0 - 64bit With the Real Application Clusters option, during the export. Somehow it keeps giving ORACLE error 1555.

Ive sized undo_tbs, set the retention time to the longest running query, but the error keeps occurring.
The table where the error appear has some Lob fields.

Taking a look in alert.log i have:

ORA-01555 caused by SQL statement below (SQL ID: atjzqd2dc3xfv, Query DurationE82 sec, SCN: 0x0721.f933dbcd):
SELECT /*+NESTED_TABLE_GET_REFS+*/ "schema"."table".* FROM "schema"."table" ORA-01555 caused by SQL statement below (SQL ID: 81xv812rrxj0m, Query Duration=0 sec, SCN: 0x0721.f933dbcd):
Mon Jan 07 14:06:47 WET 2013
SELECT SCHEMAOID      FROM  SYS.EXU9XMLST      WHERE  TOBJID = :1 ORA-01555 caused by SQL statement below (SQL ID: 81xv812rrxj0m, Query Duration=0 sec, SCN: 0x0721.f933dbcd):

Can anyone help me with this?

Tanks in advance

Arestas

PS: Sorry about my English.:\

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 08 2013 - 16:34:16 CET