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

From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 4 Nov 2006 05:38:03 -0600
Message-ID: <ufyczl12m.fsf@rcn.com>

On Fri, 3 Nov 2006, noone_at_gmail_dot_com 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

Dang,

How come Operating Systems only allow the same named file within a particular directory?

-- 
Galen Boyer

Received on Sat Nov 04 2006 - 05:38:03 CST