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>

Certainly it does, it simply does not allow that practice in a single schema:

SQL> connect bonzo/*******
Connected.
SQL> create or replace package woohoo is procedure p_woohoo; end ;

    2 /

Package created

SQL> connect nordberg/#######
Connected.
SQL> create table woohoo as select * from scott.emp;

Table created.

SQL> David Fitzjarrell Received on Fri Nov 03 2006 - 11:30:59 CST