-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|