exp ORA-01455

最新推荐文章于 2021-06-04 07:50:00 发布

lwei_998

最新推荐文章于 2021-06-04 07:50:00 发布

阅读量8k

点赞数

CC 4.0 BY-SA版权

文章标签： table statistics insert oracle system

本文链接：https://blog.youkuaiyun.com/lwei_998/article/details/7446548

本文探讨了在使用exp工具导出Oracle表结构时遇到ORA-01455错误的问题，并提供了MOS解决方案及工作规避方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在10.2.0.3.0的客户端用exp去导出11.2.0.3.0的表结构时遇到ORA-01455错误。

EXP-00008: 遇到 ORACLE 错误 1455
ORA-01455: 转换列溢出整数数据类型
EXP-00000: 导出终止失败

尝试添加这些参数后问题依旧INDEXES=n STATISTICS=none TRIGGER=N

最后换用11.2.0.3.0的客户端导出正常。

MOS中的Solution：[ID 1083330.1]

On 11.2, by default deferred segment creation future is turned on. When a table created with locally
managed tablespace then its property value is very big. If we insert any row in the table then it's
segment gets created and property value updated to 536870912.
Supported workarounds for this problem are:

1. If a table is created in this manner it is required to contain data even if the data
is then deleted afterwards.
Or:
2. Initially create the table with SEGMENT CREATION IMMEDIATE option, or set the parameter:
alter system set deferred_segment_creation=false;
and create the table afterwards in a new session.