Re: Changing Database Character Set???

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 13 Feb 2002 23:14:38 +0100
Message-ID: <35pl6u8cbd29em1b1ovsucu39ndccank67@4ax.com>

On Wed, 13 Feb 2002 12:48:10 -0600, "Douglas Scott" <dsscott_at_ev1.net> wrote:

>I'm thinking of changing my database's charater set so that I can support
>Russian characters in the database. I currently use US7ASCII and was going
>to do an export/import into a new database using that uses the UTF-8
>character set. Does anyone know of any gotchas with doing this?
>
>Thanks
>

Might not be necessary to do the exp/imp rigmarole, unless you want to reorganize your database as well. Of course, that is when you are running 8i and higher, which you don't mention. In that case an alter database character set statement, provided

- you have the database opened exclusively
- in restricted session
- with no job queue processes
- and no advanced queuing process

is sufficient.

Why does everyone think people responding here either can guess or keep track which version everyone is using? I definitely don't keep track of that

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Feb 13 2002 - 16:14:38 CST