See, If the export dump is in one characterset and the target database which has to be imported is in another characterset how could we import that particular dumpfile into target database ?

Interview Candidate
Mar 11th, 2006
2
4392

Showing Answers 1 - 2 of 2 Answers

Faraz

May 24th, 2006

In 10g exp/imp can be used to convert to character set but it can result in some data loss or data corruption.consier also when we are migrating form character set A to set B make sure to avod data loss that B is a superset of A.

aravindhreturns
Profile Answers by aravindhreturns

Jul 1st, 2009

First look into your character set by using this command:-
select * from v$nls_parameters;

There will be a character set column in it.
Copy it and
EXPORT NLS_LANG=(Paste it here before you start your import.)

I bet it'll work.