Re: ORACLE error 1555 encountered
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "ccastro7145@xxxxxxxxx" <ccastro7145@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Jan 2013 07:34:16 -0800 (PST)
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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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.:\
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
