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

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 Received on Fri Nov 03 2006 - 11:22:26 CST