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
