| IMPORT Problem [message #69565] |
Thu, 31 January 2002 19:21  |
Keshav Tripathy
Messages: 30
Registered: November 2001
|
Member |
|
|
I am trying to Import an Oracle Dump Oracle 8i Under Windows NT
I am getting the Following Error.
IMP-00069: Could not convert to environment national character set's handle IMP-00000: Import terminated unsuccessfully
I have checked with the Export Log for Character set which says that
Export done in US7ASCII character set and US7ASCII NCHAR character set
Once again I tried to Import the export dump by giving following
command
imp system@oracle_sid file=d:cbt_full_012802 full=y
The Error message is coming as follows...
Export file created by EXPORT : V09.01.07 via conventional path
import done is WE8ISO8859P1 character set and US7ASCII NCHAR character set import server uses US7ASCII character set(possible charset conversion)
IMP-00069 : Could Not Convert to Environment national character sets handle
IMP-0000 : Import Terminated Unsuccessfully.
Some Information : The Target Oracle Version is oracle 8i 8.1.6
The Instance to which Import Submitted uses US7ASCII National Character Set as well as US7ASCII Character set.
If you have any solution reply
Keshav
|
|
|
|
| Re: IMPORT Problem [message #69569 is a reply to message #69565] |
Fri, 01 February 2002 13:35  |
José Luis Delgado Solano
Messages: 9
Registered: January 2002
|
Junior Member |
|
|
Hi...
your problem is your ENVIRONMENT variable
unset your NLS_LANG variable y try again your import...
If,... this solution still does not work...
try this:
From the machine where you want to IMPort the data, do this command:
c:>exp user/password@YOUR_TARGET_MACHINE
and the rest of the parameters!
then import!
this second solution WORKS!
I have tested (because I already had had this problem)...
Hope this helps!
Regards!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
