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
    I'm getting ORA-01406: fetched column value was truncated error during full export.


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

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

    Username: sys

    Connected to: Oracle8i Enterprise Edition Release - Production
    With the Partitioning option
    JServer Release - 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
    Do you have object types in your DB? If you do - then you may need to apply a patch - ref BUG: 1874468.


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