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
Export: Release 22.214.171.124.0 - Production on Mon Aug 20 23:49:48 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 126.96.36.199.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 188.8.131.52.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
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.
Click Here to Expand Forum to Full Width