expdp 错误信息ORA-01555:
【摘要】 报错日志:ORA-31693: Table data object "ZMINFO"."BONDBASEINFO" failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing dataORA-01555: snapshot too old: rollback s...
报错日志:
ORA-31693: Table data object "ZMINFO"."BONDBASEINFO" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small
ORA-31693: Table data object "ZMINFO"."ANNOUNMT" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 9 with name "_SYSSMU9$" too small
. . exported "ZMINFO"."BYIELDCURVE" 45.40 GB 472827729 rows
. . exported "ZMINFO"."ISSWEIGHT" 37.97 GB 347057094 rows
ORA-31693: Table data object "ZMINFO"."FINFO" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small
. . exported "ZMINFO"."BESTIMATE" 12.98 GB 89206815 rows
解决方法:
调大 RETENTION
SQL> ALTER SYSTEM SET UNDO_RETENTION = 3600 scope=both;
【版权声明】本文为华为云社区用户原创内容,转载时必须标注文章的来源(华为云社区)、文章链接、文章作者等基本信息, 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱:
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论(0)