Re: SQLServer2k to Oracle 9i, Character Set Conflict

On 10 Jul 2004 04:40:19 -0700, xtanto_at_hotmail.com (Krist) wrote:

>Hi Sybrand,
>Thanks for your reply.
>
>> WE8MSWIN1252, sorry. And as the new characterset is not a superset of
>> the old, recreating the database is the only way.
>
>Can I do just ALTER DATABASE CHARACTER SET WE8MSWIN1252;
>
>There is nothing yet in the database except for Scott's data.
>What is the bad thing of doing just ALTER DATABASE ... instead of
>recreating the database ?
>
>Thank you for your help,
>Krist
>

On 9i this might work. On 8i it doesn't.

--
Sybrand Bakker, Senior Oracle DBA