Re: Converting from WE8ISO8859P1 to UTF8

> I tried running exp/imp with rows=n but import still refuses to run
> due to the different char-sets.

Import on the new system won't run due to the different character sets as you have already discovered. But you can still use exp/imp to create your schema.

1. In your source database, export with rows=n. This creates your DDL scripts.
2. With your source database, import with show=y log=logfile. This will not actually perform an import, but will show you the DDL statements. The log parameter (as you are most likely aware of) will spool the output to a file.
3. Edit the file to your hearts content and then run the file on your target database.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================