Re: Schema case sensitive in Oracle?
Date: 2 Aug 2002 15:58:03 -0700
Message-ID: <42ffa8fa.0208021458.4370d6e4_at_posting.google.com>
Apparently you can. But it is a bad, bad idea to do so. If you put the user name in double quotes you can create many, not just 2, users of the same name with different mixture of upper/lower cased letters. For example, "Mary", "mary", "MARY". As far as I know, all ORACLE identifiers bahave this way. With tables, you will have to use the double quotes to reference the them correctly in all your codes. It will get vey nasty. With users, it can only be worse, I imagine.
"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
Received on Sat Aug 03 2002 - 00:58:03 CEST