In order to cahnge the charcter set of of your database .You need to rebuild the database.use database configuration assistant to create a new database there is a option to change the character set of the DB on its GUI utility.
If you run import without changing the caharcterset your data will be useless
Import and characterset conversion will not work if your dump file was made in chartacterset which is subset of characterset you are importing to, I mean US7ASCII is a subset of WE8ISO8859P1, you will be able to import from US7ASCII to WE8ISO8859P1, but you will not be able to import from superset to subset. Do you understand now?
Originally posted by Sekhar Imp will not stop you because of character set conversion. It takes care auotmatically. Thats why i could not understand what is actual problem
If you run import from US7ASCII to WE8ISO8859P1 you may lose national characters, it may depend on Oracle version. I had this porblem in 8.1.5, (the same with UTF8)
Automatic characterset conversion does not work perfect.
Originally posted by hrishy If you run import without changing the caharcterset your data will be useless