Re: Views and tables
- From: Sharon.Kovac@xxxxxxxxxxxxxxx
- To: cemail_219@xxxxxxxxxxx
- Date: Mon, 16 Nov 2009 14:01:17 -0600
No can do.
SQL> create table t
2 (key_field number);
Table created.
SQL> create view t
2 as select * from t;
create view t as select * from t
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Sharon Kovac | RotoMetrics | E-mail: Sharon.Kovac@xxxxxxxxxxxxxxx |
Phone: 636-587-3600
[ 800 Howerton Lane Eureka, Missouri 63025 USA ]
"J. Dex" <cemail_219@xxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
11/16/2009 01:58 PM
Please respond to
cemail_219@xxxxxxxxxxx
To
<oracle-l@xxxxxxxxxxxxx>
cc
Subject
Views and tables
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.
---------------------------------------------------------------------
This e-mail message is intended only for the personal use of the recipient(s)
named above. This message is confidential. If you are not an intended
recipient, you may not review, copy or distribute this message. If you have
received this communication in error, please notify the sender immediately by
e-mail and delete the original message.
---------------------------------------------------------------------
.
Other related posts:
