oracle export/import error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oracle export/import error

  1. #1
    Join Date
    Aug 2007
    Posts
    5

    oracle export/import error

    hi i try to export tables in oracle-9i.
    but i got one error message .i cant solve tat problem.
    i'm using linux environment.plz help me

    coding as follows
    -----------------------


    /wd/arul>exp

    Export: Release 9.2.0.5.0 - Production on Mon Aug 20 23:49:48 2007

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    Username: finuser
    Password:

    Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    Enter array fetch buffer size: 4096 >

    Export file: expdat.dmp > san.dmp

    (2)U(sers), or (3)T(ables): (2)U > 3

    Export table data (yes/no): yes > y

    Compress extents (yes/no): yes > n

    EXP-00094: Could not convert to server national character set's handle
    EXP-00000: Export terminated unsuccessfully

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    How many ORACLE_HOMEs do you have in that box?
    If more than one, are you sure you have set the right one before attempting export?

    If you do... echo $LD_LIBRARY_PATH
    what do you see?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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