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: <fitzjarrell_at_cox.net>
Date: 3 Nov 2006 09:30:59 -0800
Message-ID: <1162575059.638712.66560@b28g2000cwb.googlegroups.com>

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

Original text of this message

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