Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> problem with export/import
Hi
I tried to export a table so I could drop it and re-import it to get it all into one extent. However, when I import I get this. Can someone help me out and explain why? Thanks in advance. Oracle 7.3.4 on Solaris 2.6.
<snip>
Import file: expdat.dmp > /tmp/aw.dmp
Enter insert buffer size (minimum is 4096) 30720>
IMP-00038: Could not find environment character set handle IMP-00021: operating system error - error code (dec 2, hex 0x2) IMP-00000: Import terminated unsuccessfully
I've gone through the docs about language and NLS settings. I've set all the environment variables I can find but no luck. And my tables are getting larger and slower... :-(
If you can, an email to andrew.williamson who's at highland.gov.uk would be great. Thanks!
Andrew Received on Fri Nov 26 1999 - 10:53:31 CST