DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: EXP problem

  1. #1
    Join Date
    Feb 2002
    Posts
    59
    Could somebody help me with this error message:
    "ORA-01455: converting column overflows integer datatype"
    Thank you.

    Here is what I got:

    exp sh/sh@hodb file=sh-hodb.dmp owner=sh consistent=Y

    Export: Release 8.1.7.0.0 - Production on Fri Apr 19 10:51:58 2002

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
    With the Partitioning option
    JServer Release 9.0.1.1.1 - Production
    Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set
    server uses WE8MSWIN1252 character set (possible charset conversion)

    About to export specified users ...
    . exporting pre-schema procedural objects and actions
    . exporting foreign function library names for user SH
    . exporting object type definitions for user SH
    About to export SH's objects ...
    . exporting database links
    . exporting sequence numbers
    . exporting cluster definitions
    . about to export SH's tables via Conventional Path ...
    . . exporting table CAL_MONTH_SALES_MV 35 rows exported
    . . exporting table CHANNELS 5 rows exported
    . . exporting table COSTS
    . . exporting partition COSTS_Q1_1998 57879 rows exported
    . . exporting partition COSTS_Q2_1998 58450 rows exported
    . . exporting partition COSTS_Q3_1998 52570 rows exported
    . . exporting partition COSTS_Q4_1998 65803 rows exported
    . . exporting partition COSTS_Q1_1999 66940 rows exported
    . . exporting partition COSTS_Q2_1999 67825 rows exported
    . . exporting partition COSTS_Q3_1999 60968 rows exported
    . . exporting partition COSTS_Q4_1999 75590 rows exported
    . . exporting partition COSTS_Q1_2000 78468 rows exported
    . . exporting partition COSTS_Q2_2000 78036 rows exported
    . . exporting partition COSTS_Q3_2000 70424 rows exported
    . . exporting partition COSTS_Q4_2000 54812 rows exported
    . . exporting table COUNTRIES 19 rows exported
    . . exporting table CUSTOMERS 50000 rows exported
    . . exporting table FWEEK_PSCAT_SALES_MV 149325 rows exported
    . . exporting table MVIEW$_EXCEPTIONS 0 rows exported
    . . exporting table MV_CAPABILITIES_TABLE 0 rows exported
    . . exporting table PLAN_TABLE 0 rows exported
    . . exporting table PRODUCTS 10000 rows exported
    . . exporting table PROMOTIONS 501 rows exported
    . . exporting table REWRITE_TABLE 0 rows exported
    . . exporting table SALES
    . . exporting partition SALES_Q1_1998 71805 rows exported
    . . exporting partition SALES_Q2_1998 72705 rows exported
    . . exporting partition SALES_Q3_1998 63390 rows exported
    . . exporting partition SALES_Q4_1998 83415 rows exported
    . . exporting partition SALES_Q1_1999 86217 rows exported
    . . exporting partition SALES_Q2_1999 87298 rows exported
    . . exporting partition SALES_Q3_1999 76139 rows exported
    . . exporting partition SALES_Q4_1999 100110 rows exported
    . . exporting partition SALES_Q1_2000 104544 rows exported
    . . exporting partition SALES_Q2_2000 104652 rows exported
    . . exporting partition SALES_Q3_2000 91260 rows exported
    . . exporting partition SALES_Q4_2000 74736 rows exported
    EXP-00008: ORACLE error 1455 encountered
    ORA-01455: converting column overflows integer datatype
    EXP-00000: Export terminated unsuccessfully

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Metalink points to 2 possibilities for this error during an export. Both have to do with integer datatypes .. that's the key.

    Do you have a number higher than 32767? That's bug #1044883.

    Do you have any negative numbers in integer columns?

    You might think of changing those integer columns to number(0).
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width