Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why Oracle Enforce Name Uniquness ???!!!

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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 04 Nov 2006 07:35:49 +0100
Message-ID: <eig23g$6ub$2@news2.zwoll1.ov.home.nl>


klabu schreef:
> 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>
>
>

It does not - as documented, names must be unique *within the same namespace*.
Tables and packages share the same namespace.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Sat Nov 04 2006 - 00:35:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US