Re: Why Oracle Enforce Name Uniquness ???!!!

bdbafh wrote:
> klabu wrote:
> > Dang !
> >
> > why Oracle does not allow a table to have same name as another object type
> > ???!!!
> >
> > SQL> create or replace package woohoo is procedure p_woohoo; end ;
> > 2 /
> >
> > Package created
> >
> > SQL> create table woohoo as select * from scott.emp;
> >
> > ORA-00955: name is already used by an existing object
> >
> >
> >
> > <10gR2>
>
> just use double quotes and mixed case and you'll be fine.
>
> -bdbafh

Therein lies the road to maintenance hell. Received on Fri Nov 03 2006 - 11:54:37 CST