Importing from Oracle 10g

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.

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.
>

Thank you.  I will contact the Oracle DBA.