I had to import an dump file to an oracle 11.2 express database instance.
The target instance uses AL16UTF16 for the national character set encoding, but the source instance uses UTF8. So the problem is, that rows where rejected on import because AL16UTF16 uses twice as many bytes as UTF8 an the column can't take the row values.
I think it is the easiest way to change the national character set encoding, but how do I do that?
I tried to use csscan an csalter for altering the encoding but I think that isn't available in the express instance.
Thanks for your help.