ORACLE 导出报错

最新推荐文章于 2022-02-18 11:12:40 发布

m13632750052

最新推荐文章于 2022-02-18 11:12:40 发布

阅读量563

点赞数 1

分类专栏： oracle 文章标签： oracle exp

oracle 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

oracle 11g exp 导出用户数据时报错：

EXP-00008: 遇到 ORACLE 错误 1455

ORA-01455: 转换列溢出整数数据类型

EXP-00000: 导出终止失败

参考 onemetre 文章

解决方法：

select 'alter table '||table_name||' allocate extent;'from user_tables WHERE SEGMENT_CREATED='NO';

执行下面语句后可以导出

'ALTERTABLE'||TABLE_NAME||'ALL
alter table IM_UNLOAD_D allocate extent;
alter table IM_UNLOAD_M allocate extent;
alter table TMP_RPT_STOREKUCUN allocate extent;
alter table TMP_RPT_MISSTOREKUCUN allocate extent;
alter table CONTAINER_CONTENT_2KK_170702 allocate extent;
alter table CONTAINER_CONTENT_2KK_160625 allocate extent;
alter table OM_OUTSTOCK_DOCK allocate extent;
alter table IM_BILLBOARDS_LICENSEPLATE allocate extent;
alter table DXSTASKFOCUS_BAK_Z20160414 allocate extent;
alter table OM_DELIVERCAR_MSG allocate extent;
alter table IM_BILLBOARDS_STATUS_LOG allocate extent;
alter table CONTAINER_CONTENT_2KK_161202 allocate extent;
alter table IM_BILLBOARDS_STATUS allocate extent;
alter table IM_BILLBOARDS_D allocate extent;
alter table IM_BILLBOARDS_D_HIS allocate extent;
alter table IM_BILLBOARDS_LOG allocate extent;
alter table IM_BILLBOARDS_M allocate extent;
alter table IM_BILLBOARDS_M_HIS allocate extent;
alter table IM_BILLBOARDS_PUSH allocate extent;
alter table IM_BILLBOARDS_STUDY allocate extent;
alter table OM_LOCATE_ORDER allocate extent;
alter table IM_BILLBOARDS_TIME_SET_TMP allocate extent;
alter table CH_CONTAINER_REVIEW allocate extent;
alter table IM_RECEIVING_TRANSFER allocate extent;
alter table CONTAINER_CONTENT_2KK_171126 allocate extent;
alter table DI_PERFORM_D_HIS allocate extent;
alter table CONTAINER_CASE_LABEL allocate extent;
alter table OM_1GG_FOR_TMS allocate extent;