Re: How can I alter the parameter nls_sort

On Monday, December 8, 2014 5:52:50 AM UTC-8, fastb..._at_gmail.com wrote:
> On Tuesday, June 24, 2008 3:40:36 AM UTC-4, gzja..._at_gmail.com wrote:
> > 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
>
> Jack, Can you post the code for your trigger ?
> Thanks
> -Sam

You do realize you are responding to a six year old post?

jg

-- 
_at_home.com is bogus.
http://www.theregister.co.uk/2014/12/05/oracle_zfs_filer/