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

Thread: Error during export

  1. #1
    Join Date
    Jan 2001
    Posts
    24
    Connected to: Oracle8 Release 8.0.3.0.6 - Production (5 User Edition)
    With the Partitioning and Objects options
    PL/SQL Release 8.0.3.0.2 - Production
    Export done in WE8ISO8859P1 character set and WE8PC850 NCHAR character set

    About to export specified users ..
    . exporting foreign function library names for user AUTOD
    . exporting object type definitions for user AUTOD
    About to export AUTOD's objects ...
    . exporting database links
    . exporting sequence numbers
    . exporting cluster definitions
    . about to export AUTOD's tables via Conventional Path ..
    . . exporting table ACCESSORY_MAST 0 rows exported
    . . exporting table ACC_INVOICE_DTL 0 rows exported
    . . exporting table RO_CAR_DTL 3246 rows exported
    . . exporting table RO_COMPL_DTL 7168 rows exported
    . . exporting table RO_HDR
    EXP-00056: ORACLE error 1410 encountered
    ORA-01410: invalid ROWID
    . . exporting table RO_OPR_DTL 5616 rows exported
    . . exporting table VEH_GRN_DTL 486 rows exported
    . . exporting table VEH_GRN_HDR 486 rows exported
    . . exporting table VEH_HISTORY
    EXP-00015: error on row 777 of table VEH_HISTORY, column ORDER_NUM, datatype 1
    EXP-00001: data field truncation - column length=12, buffer size=12 actual size=4294967295
    . . exporting table VEH_INVOICE 20 rows exported
    . . exporting table VEH_INV_CHARGES 60 rows exported



    while exporting the user i am getting the error ora-01410 invalid rowid. and exp 00001 data field truncation
    How to avoid these error ?



    R.John Dhinakaran

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    I heard 803 is very buggy, upgrade to 804 at least

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    what are the options that you were using during export.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Jan 2001
    Posts
    24

    Export options

    default options are used.
    R.John Dhinakaran

  5. #5
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    you have 2 kind of problem:
    1. the export you have is a different version of import one
    2. the caracter set of exp is different of imp caracter set
    ....so you can run the catexp of the export version and try the imp...(you may restore later )

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