Re: export problem - snapshot too old

You're export is using consistent=y (the manual says the default is N but it is actually Y). If you're absolutely sure than no updates are taking place while the export runs, exp consistent=n will solve the problem. It'll also run a heck of a lot faster. Note there's a new direct=y option with 7.3 that makes it go faster also and seems to work well.

Mahesh Anand wrote:
>
> As your message says Rollback Segment too small. Increase the rollback
> segment.
>
> Patrick Tan wrote:
>
> > Environment
> > Oracle 7.1.6
> > HPUX 10.01
> >
> > My nightly database export encounter the following problem recently.
> > This does not happen every night but averaging once in 5 nights.
> >
> > .exporting table ................
> > .exporting table CF_COMMIT 184019 rows exported
> > EXP-00008: ORACLE error 1555 encountered
> > ORA-01555: snapshot too old (rollback segment too small)
> > EXP-00222:
> > System error message 2
> > EXP-00000: Export terminated unsuccessfully
> >
> > It failed at different tables and there is no insert, update and
> > delete
> > activities on the database when I perform the database export. Please
> > help. I am using unix pipe to export the database directly to gzip
> > format.
> >
> > Patrick
 

-- 
Gary Melhaff
Senior Database Analyst
Weyerhauser Corporation