Re: NLS probleam

From: Gerold Krommer <xgkrommer_at_fns.co.at>
Date: Tue, 21 Nov 2000 10:20:20 +0100
Message-ID: <8vdf22$hg8$1@news.netway.at>

This worked for me.

SVRMGR>startup mount exclusive pfile=/fnsw/local/oracle/init.ora
SVRMGR>alter system enable restricted session;
SVRMGR>alter database open;
SVRMGR>alter database indexdb character set WE8ISO8895P1;
SVRMGR>alter database indexdb national character set WE8ISO8895P1;
SVRMGR>shutdown normal

PS: It IS possible to change the character set later, as long as it is a strict superset of the original one ( eg US7ASCII -> WE8ISO8859P1) starting with Oracle8. Received on Tue Nov 21 2000 - 03:20:20 CST