X-Received: by 10.50.29.52 with SMTP id g20mr17289307igh.7.1418056932232; Mon, 08 Dec 2014 08:42:12 -0800 (PST) X-Received: by 10.140.29.230 with SMTP id b93mr13983qgb.26.1418056932193; Mon, 08 Dec 2014 08:42:12 -0800 (PST) Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!195.208.113.2.MISMATCH!goblin2!goblin3!goblin.stu.neva.ru!news.ripco.com!news.glorb.com!h15no15597370igd.0!news-out.google.com!n9ni21qai.0!nntp.google.com!w8no5491644qac.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Mon, 8 Dec 2014 08:42:11 -0800 (PST) In-Reply-To: <549ee6da-777a-418b-a61d-7d5454f698fc@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=64.58.150.28; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv NNTP-Posting-Host: 64.58.150.28 References: <846v54pff4tlera8loe8apt8cmdkli1s9b@4ax.com> <549ee6da-777a-418b-a61d-7d5454f698fc@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <82f29e39-37e5-4090-869e-a42f4e5d1092@googlegroups.com> Subject: Re: How can I alter the parameter nls_sort From: joel garry Injection-Date: Mon, 08 Dec 2014 16:42:12 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Xref: news.cambrium.nl On Monday, December 8, 2014 5:52:50 AM UTC-8, fastb...@gmail.com wrote: > On Tuesday, June 24, 2008 3:40:36 AM UTC-4, gzja...@gmail.com wrote: > > On Jun 23, 8:37=A0pm, sybra...@hccnet.nl wrote: > > > On Mon, 23 Jun 2008 01:59:37 -0700 (PDT), gzjack...@gmail.com wrote: > > > >I used "alter system set nls_sort =3D binary_ci scope =3D 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 correc= t > > > 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 > >=20 > > I used an after logon trigger.It's done! > >=20 > > Thank u very much! > > Jack.Lee >=20 > Jack, Can you post the code for your trigger ?=20 > Thanks > -Sam You do realize you are responding to a six year old post? jg --=20 @home.com is bogus. http://www.theregister.co.uk/2014/12/05/oracle_zfs_filer/