9i客户端导出11gR2库的数据报错
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully
oracle@ndb3:~/backup>
oracle@ndb3:~/backup>
因为前面成功导出有表,报错时按顺序应该导的表去检查
SQL>
SQL> select * from baserights t;
no rows selected
SQL>
发现这个表没有记录
这是11gR2的新特性，对一个新建的表，不会分配segment，当insert记录时才会分配段，再检查这个参数
SQL> show parameter deferred_segment_creation
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
deferred_segment_creation boolean TRUE
SQL>
解决办法
方法1、insert一行，再rollback就产生segment了。该方法是在在空表中插入数据，再删除，则产生segment。导出时则可导出空表。
方法2、设置deferred_segment_creation 参数 ,该参数值默认是TRUE，当改为FALSE时，无论是空表还是非空表，都分配segment。修改SQL语句：
alter system set deferred_segment_creation=false scope=both;需注意的是：该值设置后对以前导入的空表不产生作用，仍不能导出，只能对后面新增的表产生作用。如需导出之前的空表，只能用第一种方法。
用以下这句查找空表select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0;
把查询结果导出，执行导出的语句，强行修改segment值，然后再导出即可导出空表
以下处理后成功导出
SQL> alter table BASERIGHTS allocate extent;
alter table BASEUSERRELATION allocate extent;
alter table CIQ_PACK_APL_BAK allocate extent;
alter table CIQ_PACK_DISPART allocate extent;
alter table CIQ_PACK_DISPART_BAK allocate extent;
alter table CIQ_PACK_MODEL_BAK allocate extent;
alter table CIQ_T_ORG_INFO_1 allocate extent;
alter table F_ENT_ITEM_EXPENSE allocate extent;
alter table F_TEST allocate extent;
alter table M_DECL_RESPONSE allocate extent;
alter table PACERT_CERTINFO allocate extent;
alter table PACERT_DEFAULT allocate extent;
alter table PACERT_GOODSINFO allocate extent;
alter table PBCATCOL allocate extent;
alter table PBCATTBL allocate extent;
alter table PBCATVLD allocate extent;
alter table PLAN_TABLE allocate extent;
alter table SHEN_DECL allocate extent;
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL>
Table altered.
SQL> SQL>
User to be exported: (RETURN to quit) >
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user EPORT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user EPORT
About to export EPORT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export EPORT's tables via Conventional Path ...
. . exporting table ADMINISTRATOR_ROBIN 2 rows exported
. . exporting table APPLICATION_LOG 3836 rows exported
. . exporting table ATTRACTION 1 rows exported
. . exporting table BASEFUNCTION 15 rows exported
. . exporting table BASERIGHTS 0 rows exported
. . exporting table BASEUSER 10202 rows exported
. . exporting table BASEUSERFUNCRIGHT 52300 rows exported
. . exporting table BASEUSERFUNCRIGHT_20080429 27457 rows exported
. . exporting table BASEUSERRELATION 0 rows exported
. . exporting table BASEUSER_BLOCK 65 rows exported
. . exporting table BASEUSER_BLOCK_120111 12 rows exported
. . exporting table BASEUSER_BLOCK_BAK 21 rows exported
. . exporting table BASEUSER_ISYS 166 rows exported
. . exporting table BORKER 54 rows exported
. . exporting table CIQ_PACK_APL 2 rows exported
. . exporting table CIQ_PACK_APL_BAK 0 rows exported
. . exporting table CIQ_PACK_DEFAULT 2 rows exported
. . exporting table CIQ_PACK_DISPART 0 rows exported
. . exporting table CIQ_PACK_DISPART_BAK 0 rows exported
. . exporting table CIQ_PACK_MODEL 2 rows exported
. . exporting table CIQ_PACK_MODEL_BAK 0 rows exported
. . exporting table CIQ_T_ORG_INFO 1011 rows exported
. . exporting table CIQ_T_ORG_INFO_1 0 rows exported
. . exporting table CIQ_T_ORG_INFO_20100110 970 rows exported
. . exporting table CIQ_T_PACK_TYPE 89 rows exported
. . exporting table CONVERT_PROVINCE 36 rows exported
. . exporting table CONVERT_TEMP 1304 rows exported
. . exporting table COPY_USERS 1 rows exported
. . exporting table CT_HS_CODE_BAK 12225 rows exported
. . exporting table C_ORG_CODE 1 rows exported
. . exporting table ENT_KIND 7 rows exported
. . exporting table EPORT_ERRORS_ROBIN 5 rows exported
. . exporting table EPORT_LOG_ROBIN 3 rows exported
. . exporting table F_BUSINESS_POLICY 2 rows exported
. . exporting table F_DECLTYPE_FUNC_CONV 7 rows exported
. . exporting table F_DECL_DETAILS