Character set Problems in Migration 7.3.4.5 -> 8.1.7.0

Hi all:

I have been trying to test the migration process of a 7.3.4.5 DB to a 8.1.7.0 running on an IBM H80 4.3.3. I am getting hung up using the commandline Migration tool and character sets, I've tried Oracle's ODMA GUI, but, that's not working either. The character currently set is Western European(why I do not know) WE8ISO8859P1. I have the NLS_LANG environment var set then run the migration tool and receive ORA-12705, saying that I have an invalid or unknow NLS parameter, but, the client char set and server char set are the same. I've checked and double checked and do not find anything wrong. Then just for giggles, I tried unsetting the NLS_LANG environment var so that it defaults to US7ASCII and receive a different error from the migration utility, basically saying the client character set does not match the server. Then to go a little further, I decide to try to change the character set of the database to US7ASCII, but, after bringing it up in restricted mode and trying the alter database character set appears not to be supported. I've never had this much stinking trouble migrating a Database before.

Anyone have any ideas here? Please post a reply and email at the address below while removing SPAMMERS_STINK.

Thanks,
PETE's
epeterson_at_mnSPAMMERS_STINKpower.com Received on Fri Oct 12 2001 - 14:01:52 CDT