Re: How can I alter the parameter nls_sort
Date: Tue, 24 Jun 2008 00:40:36 -0700 (PDT)
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
> 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.
> 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