Skip site navigation (1) Skip section navigation (2)

Re: How configure Oracle 9i not case sensitive...

From: ross(at)stamina(dot)com(dot)au (Ross Ferris)
To: "pgsql-admin(at)postgresql(dot)org(dot)pgsql-bugs(at)postgresql(dot)org(dot)pgsql-docs"(at)postgresql(dot)org
Subject: Re: How configure Oracle 9i not case sensitive...
Date: 2004-04-24 15:32:38
Message-ID: 26f6cd63.0404240732.404f579d@posting.google.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugspgsql-docs
Better still, why not switch to D3 .... you can make files (tables)
case insensitive if you want - you can even selectively make the data
case insensitive, which can be "useful" for searches .... oh, if you
are using the "embedded tables" feature of 9i, the whole concept of
storing multi-values was born in the "Pick" style database arena, so
it will feel like coming home !

There may be some limitations though .... one of the threads in
computer.databases.pick is indicating that you may have to look at
application partitioning across multiple machines if you are looking
at supporting > 10,000 active, concurrent users (50-100,000 with web
deployment), but this is probably more than you want to run off a
single 9i box anyway, so probably not a practical issue to consider.

But, if you are into building an empire, populated with DBA's and
tuning experts, the multi-valued databases are probably not for you,
as a thread in comp.databases.theory indicates that TCO on
multi-valued style databases may be a fraction of Oracle.

Oh, and if you haven't heard of "multi-valued" or "Pick-style"
databases, you are in good company - one of the best kept secrets of
the industry, a virtual black hole, because once a developer devles
in, they will not want to return ! If you need a "brand name" to get
the switch past management, justb tell them that you want to join the
4 million or so users of IBM's U2 product - or you you prefer, there
are a number of other providers of (roughly) equivalent products in
the market.

And if you don't want to hear this message, don't blame me, I'm just
responding to a multiple cross-post, and enjor stirring the pot from
time to time !

sybrandb(at)yahoo(dot)com wrote in message news:<a1d154f4(dot)0404230640(dot)6d307a23(at)posting(dot)google(dot)com>...
> "Eloy Mier Pérez" <eloy(dot)mier(at)tantacom(dot)com> wrote in message news:<Ku5ic(dot)115120$Rc(dot)3299230(at)news-reader(dot)eresmas(dot)com>...
> > Hi, i would configure Oracle 9i not case sensitive and in the table names
> > dont use ""...
> > 
> > How can i do this ?
> > 
> > Thanks in advance
> 
> You can't
> Stick to sqlserver.
> 
> 
> Sybrand Bakker
> Senior Oracle DBA

In response to

Responses

pgsql-docs by date

Next:From: Joel GarryDate: 2004-04-26 22:45:08
Subject: Re: How configure Oracle 9i not case sensitive...
Previous:From: sybrandbDate: 2004-04-23 14:40:26
Subject: Re: How configure Oracle 9i not case sensitive...

pgsql-admin by date

Next:From: Edoardo CeccarelliDate: 2004-04-26 16:38:00
Subject: is a good practice to create an index on the oid?
Previous:From: Gaetano MendolaDate: 2004-04-24 10:17:17
Subject: Re: Real time replication of PG DBs accross two servers - any experiences?

pgsql-bugs by date

Next:From: Helvio HildDate: 2004-04-24 16:57:37
Subject: Killing the backends
Previous:From: Tom LaneDate: 2004-04-24 05:07:03
Subject: Re: ipcclean broken on OSX

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group