Hi Nitin,
Check the character set used in target database.
Set the same character set in enviornment variable (NLS_LANG) in registry and in CONTROL PANEL -> SYSTEM -> ENVIORNMENT
Take export and try to import in target database. See if this is helpful.

We applied same method in between export/import from oracle 7.3.2.2.1 to oracle 9i and got successful.

Neetu

-----Original Message-----
From: Nitin Gupta [SMTP:gupta.[Email Address Removed] Wednesday, July 31, 2002 11:58 AM
To: LazyDBA.com Discussion
Subject: Export/Import-Characterset difference

I want to do EXPORT from one database and IMPORT to different database, both having different CHARACTERSETS, on Oracle 8i.
How to go about it, 'error-free'? Kindly suggest some detailed document also if any, relecting various options/implications.

Best regards,
Nitin Gupta

<< File: ATT00038.htm >>
Oracle LazyDBA home page