Re: Case insensitive search

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Wed, 31 Jan 2007 05:21:31 GMT
Message-ID: <vHVvh.2951$q86.2413@trndny01>

On Tue, 30 Jan 2007 14:20:50 -0800, harvinder76 wrote:

> Hi,
>
> When we set the following parameters on the client machine with alter
> session it works fine and we get case insensitive searches but when we
> try to set this in spfile it only affects the sessions on the database
> machine:
> NLS_SORT='BINARY_CI'
> nls_comp='LINGUISTIC'
>
> Is there any way we can change this settings at the instance level so
> that we don't have to use logon trigger to set this parameters at
> session level?

Harvinder, now you are being childish. These two are parameters which can easily be modified in the spfile.

SQL> alter system set NLS_SORT='BINARY_CI' scope=memory; alter system set NLS_SORT='BINARY_CI' scope=memory

                 *

ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option

SQL> alter system set nls_comp='LINGUISTIC'scope=memory; alter system set nls_comp='LINGUISTIC'scope=memory

                  *

ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option

It would be trivial to write them with "scope=spfile" option and restart the instance.
I've seen you many times on this group, you're not a beginner. You must have known that the values you're talking about are instance parameters which are modified solely by thy DBA. The fact that you are asking the question means that you cannot do that yourself and that you're asking us how to circumvent your DBA's commandments. Naughty, naughty! Do not mention thy DBA's name in vain and above all, do not try to go around his policies, lest you want to experience his wrath.

---
http://www.mladen-gogala.com

Received on Tue Jan 30 2007 - 23:21:31 CST