OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Help Needed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help Needed [message #197907]

Fri, 13 October 2006 04:32

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.

Report message to a moderator

Re: Help Needed [message #197909 is a reply to message #197907]

Fri, 13 October 2006 04:39

Littlefoot
Messages: 21823
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

Re: Help Needed [message #197922 is a reply to message #197909]

Fri, 13 October 2006 05:10

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

Report message to a moderator

Re: Help Needed [message #197930 is a reply to message #197907]

Fri, 13 October 2006 05:51

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

Report message to a moderator