• EXP00008: ORACLE error 1455 encountered


    C:\Users\MaryHu>exp ARCER/ARCER@DB234 FILE=E:\FGPS_20130528.dmp statistics=none
    
    Export: Release 11.2.0.1.0 - Production on Tue May 28 08:04:54 2013
    
    Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
    
    Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
    
    About to export specified users ...
    . exporting pre-schema procedural objects and actions
    . exporting foreign function library names for user ARCER
    . exporting PUBLIC type synonyms
    . exporting private type synonyms
    . exporting object type definitions for user ARCER
    About to export ARCER's objects ...
    . exporting database links
    . exporting sequence numbers
    . exporting cluster definitions
    . about to export ARCER's tables via Conventional Path ...
    . . exporting table      COILS_ASSETS_DEPRECIATION         55 rows exported
    . . exporting table              COILS_CODE_ASSESS         38 rows exported
    . . exporting table          COILS_COMPANY_LICENSE         16 rows exported
    . . exporting table                      COILS_EMP          8 rows exported
    . . exporting table               COILS_LOG_ASSESS         14 rows exported
    . . exporting table                   COILS_STORES         37 rows exported
    . . exporting table           COMPANY_ANNOUNCEMENT          3 rows exported
    . . exporting table                   CRM_CUSTOMER         51 rows exported
    EXP-00008: ORACLE error 1455 encountered
    ORA-01455: converting column overflows integer datatype
    EXP-00000: Export terminated unsuccessfully
  • 相关阅读:
    SQL通配符
    全角半角内容转换
    使用merge into 来更新目标表的个别字段
    数据库分库分表思路
    impdp导入错误ORA-14460
    CentOS只有GNOME桌面,没有GNOME经典桌面
    sqlserver进行发布订阅时提示实例上未安装复制组件解决方法
    SQLSERVER发布订阅,超详细
    sqlserver查询锁以及解锁
    sqlserver调用java文件
  • 原文地址:https://www.cnblogs.com/arcer/p/3102921.html
Copyright © 2020-2023  润新知