| Import problem [message #72745] |
Fri, 10 October 2003 23:36  |
Man Mohan Sharma
Messages: 35
Registered: October 2003
|
Member |
|
|
I have a export dump of Unix environment, I want it to import on Windows environment. The export dump was of Oracle 8.0 and I want to import it in Oracle 9i. The error is coming
-------
Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
IMP-00038: Could not convert to environment character set's handle
IMP-00000: Import terminated unsuccessfully
-----------
Pls. help...
|
|
|
|
| Re: Import problem [message #72746 is a reply to message #72745] |
Sat, 11 October 2003 06:21  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
try to use the same NLS_LANG setting during both export and import .
Also use the same RECORDLENGTH value during export and import.
|
|
|
|
| Re: Import problem [message #72747 is a reply to message #72746] |
Sun, 12 October 2003 22:58 |
Man Mohan Sharma
Messages: 35
Registered: October 2003
|
Member |
|
|
I have tried with 'AMERICAN_AMERICA.WE8MSWIN1252' AND WITH 'AMERICAN_AMERICA.WE8ISO8859P1' US7ASCII. Pls. give some possible values so that I can try.
Man Mohan
India
|
|
|
|
| Re: Import problem [message #72808 is a reply to message #72745] |
Wed, 29 October 2003 04:30 |
Import Proble,
Messages: 1
Registered: October 2003
|
Junior Member |
|
|
Hi,
I want to Import the Oracle database in oracle server.In one of the table we have around 42000 records.i am able to import 17000 records only.how do i give a command to select particular rows to import the datas.
Thanks
Logu.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
