Re: turn off/on case insensetive search in Oracle DBMS

From: Keith Boulton <kboulton_at_ntlunspam-world.com>
Date: Sun, 29 Jul 2001 10:11:26 +0100
Message-ID: <GlQ87.19957$vN4.137404@news11-gui.server.ntli.net>

In 8i, function-based indexes are available only in the enterprise edition - and it's not worth an extra $500 per client or whatever the difference is now.

Given how trivial it is to implement a case insensitive search and how useful, I'm astonished that Oracle still haven't provided it (too busy writing the world's most resource hungry installer, I guess).

As for readers not blocking writers, that's right, we get ORA-1555 snapshot too old instead.

"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message news:3b62f4ca.3392270_at_news...
> On Sat, 28 Jul 2001 16:39:39 GMT, "Jim Kennedy"
> <kennedy-family_at_home.com> wrote:
>
> >Yeah, and I can't seem to get my writers and readers to block each other
yet
> >like all those other RDBMSs.
> >
>
> Hehehe!
> You wish...
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Sun Jul 29 2001 - 04:11:26 CDT