11.2.0.4 rac环境做expdp导出2张表的时候，报错
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "HZSI"."SYS_EXPORT_TABLE_01": hzsi/******** directory=bak_dir_1 dumpfile=QKC22.KC30_%U.dmp logfile=QSI_KC22_KC30.log tables=KC22
_ZYYPDETAIL,KC30_YJS exclude=statistics cluster=no compression=all parallel=6
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 595.4 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
. . exported "HZSI"."KC22_ZYYPDETAIL" 25.75 GB 1215419860 rows
ORA-31693: Table data object "HZSI"."KC30_YJS" 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 73 with name "_SYSSMU73_3843154420$" too small
Master table "HZSI"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
undo表空间截图
请问下老师 在不重启库的前提下，怎么修改，现在alert日志没有查询，需要修改undo retention的时间吗，修改的话，改成多少合适，不改的话，需要加增大undo表空间吗
UNDO表空间的数据文件设置成AUTOEXTEND ON。同时：ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; 当然这样做有可能导致UNDO表空间变大，如果能接受也无所谓。另外，两个表是否要一起导，如果能分开导最好。如果一定要一起导，那么挑一个业务较少的时间段，这时UNDO表空间比较富裕。建议把压缩选项去掉。因为压缩也会增加导出时间，现在是尽量把导出时间缩短，在UNDO耗尽前完成就好。
评论
有用 2
