| |
GeekInterview.com > Interview Questions > Oracle > Scenarios
| Print | |
Question: 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 ?
|
| July 07, 2009 02:23:11 |
#2 |
| aravindhreturns |
Member Since: July 2009 Total Comments: 5 |
RE: 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 ?
|
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. |
| |
Back To Question | |
