Erick Sasse wrote:

>>
>> This will not have changed how the data is stored in the db, only how it
>> is defined.
>
> So when I restore the db data is not restored to the proper format?
>

Err, the collation doesn't affect the stored format of data. It does
affect the stored format of indexes. The restore will create new
indexes using the new collation (at least it should). However, as
Alexandre said, using a data pump will make it much easier to correct
problems that arise.


Regards,


Ann