Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Why Oracle Enforce Name Uniquness ???!!!
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
![]() |
![]() |