Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: changing decimal character on windows
You altered the pfile, but start on spfile. It is not affected by the
change in the pfile, alias show parameters doesnt reflect the change.
Try alter system set NLS_....... target BOTH (ie. memory and spfile).
Check the doc's for command.
/Svend
Bengali wrote:
> Hi,
> i am running Oracle Database 9.2.0 on Windows 2000 ( French Language).
> I'd like to permanatly change the decimal character of my oracle instance
> from ',' to '.' .
>
> As suggested in documentation, i added to
> %ORACLE_BASE%/admin/%ORACLE_SID%/pfile/init.ora.972002192319
> the following initialization parameter : NLS_NUMERIC_CHARACTERS = ",. "
>
> But it doesn't seem to take affect after the database restart.
>
> I don't understand why?
> When i type in sqlplus 'show parameter NLS_LANGUAGE' i get:
> nls_language string AMERICAN
>
> 'show parameter NLS_TERRITORY'
> nls_territory string AMERICA
>
> 'show parameter NLS_NUMERIC_CHARACTERS'
> nls_numeric_characters string
>
> Am i proceeding the right way?
> -I also changed Windows locale from french to English ( United States) but i
> get
> the same decimal character ( i.e ,).
> - I created the database with the "database configuration assistant".
>
>
> Thanks in advance,
> Luc
>
>
>
>
Received on Thu Nov 07 2002 - 11:39:53 CST