Export: data useable with snapshot too old ?

From: Thomas Schwickert <schwickert_at_yahoo.com>
Date: Fri, 28 Sep 2001 08:01:19 +0000 (UTC)
Message-ID: <4b38917de2c6dbfeadd80c3e14078056.20305_at_mygate.mailgate.org>



Hello,

I've got a question regarding consistent export and 'snapshot too old' The reason for this is clear to me, however I'm curious if the export-file is consistent and usefull for all but the one table, the 'snapshot too old' occurs.

From the log:

. . exporting table xxx_01 46997 rows exported
. . exporting table xxx_02
EXP-00008: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 4 with name "RS3" too small
. . exporting table xxx_92 85241 rows exported
. . exporting table xxx_93 60360 rows exported
.
.
. exporting statistics

Export terminated successfully with warnings.

Ok, means this, that only the table, where the error occurs (xxx_02) isn't properly exported, but all the rest is ok ? From documentation I read this so, just want your opinions.

I can't prove it (build a new instance, import and look ) due to lack of resources and time.

( The mentioned table was really involved in inserts before the export started, and commited while the export run)

Just curious ...

Tia
 Thomas

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Fri Sep 28 2001 - 10:01:19 CEST

Original text of this message