ORA-01406: fetched column value was truncated
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01406: fetched column value was truncated

  1. #1
    Join Date
    Feb 2001
    Posts
    44
    I'm getting ORA-01406: fetched column value was truncated error during full export.

    full=y
    direct=y
    file=Full1226.dmp
    log=Full1226.log
    feedback=5000
    buffer=50000000



    Export: Release 8.1.7.2.0 - Production on Wed Dec 26 13:49:24 2001

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


    Username: sys
    Password:

    Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.2.0 - Production
    Export done in US7ASCII character set and US7ASCII NCHAR character set

    About to export the entire database ...
    . exporting tablespace definitions
    . exporting profiles
    . exporting user definitions
    . exporting roles
    . exporting resource costs
    . exporting rollback segment definitions
    . exporting database links
    . exporting sequence numbers
    . exporting directory aliases
    . exporting context namespaces
    . exporting foreign function library names
    . exporting object type definitions
    EXP-00008: ORACLE error 1406 encountered
    ORA-01406: fetched column value was truncated
    EXP-00000: Export terminated unsuccessfully


    What did I do wrong here?
    This is on 8.1.7 and Solaris 7

  2. #2
    Join Date
    Mar 2001
    Posts
    314
    Do you have object types in your DB? If you do - then you may need to apply a patch - ref BUG: 1874468.

    -amar

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