expdp 导出报ORA-01555: snapshot too old错误
来源:互联网 发布:彩虹六号围攻网络eas 编辑:程序博客网 时间:2024/06/09 22:44
ORA-31693: Table data object "APPLSYS"."FND_LOBS" failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing dataORA-01555: snapshot too old: rollback segment number 154 with name "_SYSSMU154_1434655980$" too small
SQL> show parameter undo;NAME TYPE VALUE------------------------------------ ----------- ------------------------------undo_management string AUTOundo_retention integer 900undo_tablespace string UNDOTBS1SQL> select max(maxquerylen) from v$undostat;MAX(MAXQUERYLEN)----------------16331SQL> select retention from dba_lobs where owner='APPLSYS' and table_name='FND_LOBS';RETENTION----------900
1. Modify the current UNDO_RETENTION for the database:SQL>ALTER SYSTEM SET UNDO_RETENTION = 16500 scope=both sid='*';2. Modify the LOB retention to become greater than the undersized retention parameter following the steps from Note:563470.1SQL> alter table APPLSYS.FND_LOBS modify lob(FILE_DATA) (pctversion 5);Table altered.SQL> alter table APPLSYS.FND_LOBS modify lob(FILE_DATA) (retention);Table altered.3. Query the lob retention again to verify that the change has taken hold:SQL> select retention from dba_lobs where owner='APPLSYS' and table_name='FND_LOBS';RETENTION----------16500
阅读全文
0 0
- expdp 导出报ORA-01555: snapshot too old错误
- ORA-01555: snapshot too old错误
- ORA-01555: snapshot too old
- ORA-01555 Snapshot Too Old
- ORA-01555:snapshot too old
- 数据库open报错ORA-01555: snapshot too old
- ORA-01555:snapshot too old Error (一)
- ORA-01555 Snapshot too old 解决方法 -
- ORA-01555:snapshot too old (rollback segment too small)
- 《Oracle编程艺术》学习笔记(21)-ORA-01555:snapshot too old 错误
- 【Oracle 11g】ORA-01555: snapshot too old(快照过旧)错误
- drop tablespace 与 ora-01555 snapshot too old
- ORA-01555 "Snapshot too old" - Detailed Explanation (文档 ID 40689.1)
- ORA-01555: snapshot too old
- ORA-1555: Snapshot too old的解决
- ORA-01555: snapshot too old: rollback segment number with name "" too smal
- ORA-01555: snapshot too old: rollback segment number 16 with name "_SYSSMU16_62169813$" too small
- ORA-01555: snapshot too old: rollback segment number with name "" too smal
- pandas数据结构之Series
- 100种数据恢复的方法?!
- Java+GeoTools工具包+读写shapfile文件
- Css3的Media Query方法总结—让您的网站兼容手机
- mysql基本语法总结
- expdp 导出报ORA-01555: snapshot too old错误
- 浅谈Web网站架构演变过程
- React学习资源汇总
- 根据经纬度算两点距离
- 《算法导论》学习笔记之Chapter8线性时间排序
- firewalld火墙设置
- API开发之封装接口数据返回函数
- OpenJ_Bailian 4127 迷宫问题(DFS+BFS)
- 欢迎使用CSDN-markdown编辑器