Home » SQL & PL/SQL » SQL & PL/SQL » Help Needed
icon2.gif  Help Needed [message #197907] Fri, 13 October 2006 04:32 Go to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
Hay everybody,
I m facing problem in importing data in Oracle 9i install in winxp. where the data was export in also Oracle 9i but in Win98.
can anyone tell me the solution how to import data. the export file is DMP file.
Re: Help Needed [message #197909 is a reply to message #197907] Fri, 13 October 2006 04:39 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Export and import utilities do not depend on operating system; it means that export files (your .DMP) can be used to transfer data between different operating systems. Therefore, the fact that export was done on Windows 98 and import on Windows XP doesn't mean much.

What problem are you talking about? Did you get any error messages? Could you post a screenshot?

[Updated on: Fri, 13 October 2006 04:39]

Report message to a moderator

icon2.gif  Re: Help Needed [message #197922 is a reply to message #197909] Fri, 13 October 2006 05:10 Go to previous messageGo to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
the error recieve is .
imp-00016: Required Character Set conversion < type 178 to 871 not supported

Imp-00000: import terminated unsuccessfully
Re: Help Needed [message #197930 is a reply to message #197907] Fri, 13 October 2006 05:51 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Could be

The NLS_LANG parameter setting in the database does not match the NLS_LANG parameter of the OS.

Set NLS_LANG environment variable to match the character set:

example:
run > regedit > HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE &
gt; HOME0 >
NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
icon2.gif  Re: Help Needed [message #197931 is a reply to message #197930] Fri, 13 October 2006 05:56 Go to previous messageGo to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
Thanx alot Tahpush
Re: Help Needed [message #197932 is a reply to message #197931] Fri, 13 October 2006 05:58 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Np , I hope it solves your problem Smile
Previous Topic: how to findout diffrence between creation date and sysdate
Next Topic: ORA-29024: Certificate validation failure
Goto Forum:
  


Current Time: Sun Dec 04 16:48:54 CST 2016

Total time taken to generate the page: 0.15315 seconds