This content has been marked as final. Show 2 replies
For the import session, set nls_lang char set part to the same as the export dump i.e. we8iso8859p1. Hopefully "p15" is a superset of "p1".
About the NCHAR (national) character set. Well, UTF8 to WE8ISO8859P15 is an "impossible" conversion. Unicode can hold thousands of characters and the Latin character sets up to 256 characters. You'll have to know the data and structure from the source database. For example, if there are no NCHAR columns in the source db then it might work...
Another option would of course be to create a target database with matching character sets.