At 08:58 05/06/2006, you wrote:

>Hello,
>
>I created a Database with a wrong character set and now want to change
>it.
>The problem is, that there is a lot of data in the database, I do not
>want to lose.
>
>Is there a way to change the default character set of a database
>without creating it new? Possibly with backup and restore?
>
>If not, I have to create a new database and make a data transfer from
>the old to the new database. If possible, I would avoid this.
>
>Kind regards
>Helmut

Use a two - step process :

Recreate the database (an empty database) with the correct character set.

Use a data pump to pump the data across from the old database to the
new database.

Regards

Tim