Re: Views and tables

DEV> create table conf_tmp (col1 number);

Table created.

DEV> create view conf_tmp as select col1 from conf_tmp; create view conf_tmp as select col1 from conf_tmp

            *
ERROR at line 1:
ORA-00955: name is already used by an existing object

Thanks,

-- 
Alisher Yuldashev
Senior Oracle DBA
Web  : http://www.pythian.com





> Is it possible to create a view with the same name as a table in the 

> same schema without harming an application?

>  

>  

>

> ------------------------------------------------------------------------

> Hotmail: Trusted email with powerful SPAM protection. Sign up now. 

> <http://clk.atdmt.com/GBL/go/177141665/direct/01/>


--
http://www.freelists.org/webpage/oracle-l