Skip to Main Content
Forums

Oracle Database Discussions

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!

datapump import ORA-01555 "_SYSSMU5$" too small

649622Jul 11 2008 — edited Jul 11 2008
hello

i'm running impdp and getting the following message :

ORA-01555: snapshot too old: rollback segment number 5 with name "_SYSSMU5$" too small
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1891
ORA-06512: at "SYS.DBMS_METADATA", line 3956
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6234


undo_management =>AUTO
undo_retention => 7200
undo_tablespace => UNDOTBS

undo tablespace is autoextendable and got lots of space...

any ideas about how to solve that issue ?

thank you !
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2008
Added on Jul 11 2008
#general-database-discussions
3 comments
3,733 views