Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Consistent export vs.snapshot too old.

Consistent export vs.snapshot too old.

From: Jarek Palka <jarek_at_kamsoft.com.pl>
Date: Mon, 12 Mar 2001 16:59:32 +0100
Message-ID: <3AACF264.164F3D85@kamsoft.com.pl>

During export of large database using parameter CONSISTENT=Y we received an error :

EXP-00056: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 5 with name "RB14" too small
EXP-00222:
System error message 1
System error message: No such file or directory

Becouse database is on-line 24*7 lot of transactions was in-doubt during this export. Is it possible to force export to use SELECTED rollback_segment ?
How can we avoid such errors ?

-- 
____________________________________________________________
Jaroslaw Palka <jarek_at_kamsoft.com.pl> P.I.KAMSOFT, Katowice
tel. (+48 32) 209-07-05, fax 209-07-15    POLAND
Received on Mon Mar 12 2001 - 09:59:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US