Export: data useable with snapshot too old ?
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.ORGReceived on Fri Sep 28 2001 - 10:01:19 CEST