Database Administration (MOSC)

MOSC Banner

Oracle 11.2 Express (Windows) - change character set from UTF to Western?

edited Apr 26, 2012 9:59AM in Database Administration (MOSC) 6 comments
Yes, there is software which needs western charset and crashes with ORA-12899 when running against a DB with UTF charset.
The possibilities
(a) drop XE and recreate new DB with western charset
(b) create additional instance
are working of course, but causing some problems and some time, in case of (b) I loose some available space in the 11 gb limit, in case (a) the apex is destroyed and has to be rebuilded (I didn't managed that...)

Does someone has a hint how to perform a nearly-standard installation which creates a standard XE instance with western charset??

Best regards

Laurents

lsc(thisfunnysign)hacon.de

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center