Re: ALTER DATABASE CHARACTER SET WE8DEC;

From: <coakleyj_at_hotmail.com>
Date: Tue, 08 Jun 1999 14:54:11 GMT
Message-ID: <7jjaqd$mr2$1@nnrp1.deja.com>

It was possible to change the character set by making an update to the sys.props$ table. I'm not so sure that this is supported by Oracle though - In any case, they recommend taking a full backup before hand and warn that the character set that you change to must be compatible with the one you're changing from. In addition, if you change the characterset to an invalid value, you will not be able to start the instance.

Thus, yes, it was always possible to make the change, but required changes to sys tables (not a good idea). The "Alter database characterset" is thus a new command to achieve the same ( I presume it provides a safer environment as a result - although I haven't used it yet).

Coakleyj

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 08 1999 - 09:54:11 CDT