Posted by Dan Guzman on 01/25/06 04:17

One possible cause is that your Oracle UNDO tablespace isn't sized large
enough to accommodate data modifications made during the import. In that
case, you might try running the process during a time of less update
activity or increase the UNDO tablespace size.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"db55" <chfran@gmail.com> wrote in message
news:1138139643.416635.125020@g14g2000cwa.googlegroups.com...
>I am trying to import 6M records in a table from an Oracle 10g database
> into a SQL Server 2000 database.
>
> After importing 1.5M+ records I get the following error:
>
> Ora-01555: snapshot too old: rollback segment number 129 with name
> "_SYSSMU129$" too small
>
> How can I speed up the import process between Oracle and SQL Server?
> The database box I'm using has 12GB of memory and 1.5 TB of space. It
> shouldn't be a hardward problem. :-)
>
> Thanks in advance.
>

[Back to original message]