Re: Views and tables

From: Alisher Yuldashev <>
Date: Mon, 16 Nov 2009 15:00:42 -0500
Message-ID: <>

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


Alisher Yuldashev
Senior Oracle DBA
Web  :

> 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.
> <>
Received on Mon Nov 16 2009 - 14:00:42 CST

Original text of this message