Re: Views and tables
- From: Alisher Yuldashev <yuldashev@xxxxxxxxxxx>
- To: cemail_219@xxxxxxxxxxx
- Date: Mon, 16 Nov 2009 15:00:42 -0500
No, it's not.
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/>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
