Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Consistent export vs.snapshot too old.
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 POLANDReceived on Mon Mar 12 2001 - 09:59:32 CST
![]() |
![]() |