- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-17 11:59:14
|
查看: 1562 |
回复: 0
RHEL4.3 1O.2.0.2
最近导出这个表有问题, 总是报如下的错误, 请大家帮忙看看, 这个表里有50W的数据.
/u01/app/oracle/>exp system/system tables=SPIDER2.T_WS_COMPANY file=1122company.dmp log=1122company.log
Export: Release 10.2.0.1.0 - Production on Wed Nov 22 10:24:09 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
Current user changed to SPIDER2
. . exporting table T_WS_COMPANY
.EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old
[/COLOR]
Export terminated successfully with warnings
已经连续几天出现这个问题, 刚才我手动做这个表也是这个问题!
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
TABLESPACE_NAME TOTAL USED USED_PCT
------------------------------ ---------- ---------- ----------
UNDOTBS1 2000 422 21.1
这个表只有50W的数据, 同样的操作, 处理同样用户下的几百W的表都没有问题!
undo_retention从900增加到3600 后, 错误依然!
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 3600
undo_tablespace string UNDOTBS1
|
|