Re: How can I alter the parameter nls_sort

From: <gzjacklee_at_gmail.com>
Date: Tue, 24 Jun 2008 00:40:36 -0700 (PDT)
Message-ID: <f036b201-3648-4b59-bb4b-cd315c8ac197@r37g2000prm.googlegroups.com>


On Jun 23, 8:37 pm, sybra..._at_hccnet.nl wrote:
> On Mon, 23 Jun 2008 01:59:37 -0700 (PDT), gzjack..._at_gmail.com wrote:
> >I used "alter system set nls_sort = binary_ci scope = spfile" to
> >change the default value of the parameter nls_sort.Then I restarted
> >the service of the database instance.I saw the instance value has
> >changed.Now the problem is when I create a new connection the value of
> >nls_sort was not binary_ci but binary.I don't know why the session
> >value was not changed.
>
> >any advice will be appreciated!
>
> >Thanks a lot
> >Jack.Lee
>
> Instance settings can be, and usually are, overridden by session
> specific values.
> Oracle always sends a series of alter session statements immediately
> after logon.
> Those can be changed by setting a registry string value in the correct
> hive for Windows, or by setting an environment variable on Unix in
> your .profile.
> You can also use an execute immediate statement in an after logon
> database trigger.
>
> Hth
>
> --
> Sybrand Bakker
> Senior Oracle DBA

I used an after logon trigger.It's done!

Thank u very much!
Jack.Lee Received on Tue Jun 24 2008 - 02:40:36 CDT

Original text of this message