ORACLE 導出報錯

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;