9i匯出11gR2庫報錯ORA-01455: converting column overflows integer datatype

9i客戶端匯出11gR2庫的資料包錯
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully
>
>
因為前面成功匯出有表,報錯時按順序應該導的表去檢查

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