bdbafh wrote:
> 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>
>
> just use double quotes and mixed case and you'll be fine.
>
> -bdbafh
Why help someone do something that is a bad practice by teaching them
an even worse one?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Nov 03 2006 - 13:08:32 CST
