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 -> Why Oracle Enforce Name Uniquness ???!!!

Why Oracle Enforce Name Uniquness ???!!!

From: klabu <noone_at_gmail_dot_com>
Date: Fri, 3 Nov 2006 11:47:32 -0500
Message-ID: <12kmsl5lsp4gn4f@corp.supernews.com>


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> Received on Fri Nov 03 2006 - 10:47:32 CST

Original text of this message

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