Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01555 in importing table

703702Jun 16 2009 — edited Jun 29 2009

i have used a script to export a table from a database located in a machine and i'm importing the content of the table to another machine.
The table has 207 7390260 records.

But in the process of importing the data, it occurs the error: ORA-01555: snapshot too old: rollback segment number 2 with name "_SYSSMU2$" too small.

i've tried to change my undo_retention parameter to 1800, but the error continues to occur. i'm not sure if i can increase the undo_retention to a much bigger size. can i?

I'm using oracle 10g

here are some information about the undo tablespace:

AUTOEXT Tablespace Name File Name Size (M) Size (MaxMBytes) Used (M) Free (M)
--- -------------------- ----------------------------- ---------- ------------------ --------- ----------
YES UNDOTBS1 undotbs01.dbf 6000 131071,94 15,25 5967,88