Re: Schema case sensitive in Oracle?

"Alex Ivascu" <alex_at_ivascu.comNOSPAM> wrote in message news:<elz29.31403$Ru5.11176_at_rwcrnsc52.ops.asp.att.net>...
> There is no setting in Oracle to set it to case sensitive. And, no you
> can't have two schema's w/ the same name - in one database either. Hope
> this helps.
>
> Alex Ivascu
>
>
> "Wormie" <ordeith_at_coruscant.net> wrote in message
> news:df31f670.0208020716.64f0ecea_at_posting.google.com...
> > Is it possible to have two schemas of the same name, with different
> > case sensitivities?
> >
> > Thanks

Actually, that's not entirely true. You for example:

create user test identified by test;
create user "Test" identified by "Test";

Then
connect "Test"/"Test"

You can then have two schemas with a mixed case, but you have to enclose the user name and /or password in double quotes when connecting.

Basically, everything in Oracle is case insensitive by default, however, this can be overridden by enlosing the user/object name in quotes. Received on Sat Aug 03 2002 - 00:46:38 CEST