ORACLE error 1555 encountered

From: carlos castro <ccastro7145_at_gmail.com>
Date: Tue, 8 Jan 2013 09:00:00 +0000
Message-ID: <CAA00uROny9Ss4t7vporKKHOoiVzUMHhyh13bLPMaUs73S6Kddg_at_mail.gmail.com>

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 Duration=4582 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

Received on Tue Jan 08 2013 - 10:00:00 CET