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
  • 4
  • 4302

Showing Answers 1 - 4 of 4 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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions