Re: Views and tables
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Mon, 16 Nov 2009 21:02:23 +0100
Message-Id: <6BF8FE23-CAF4-4FB6-A554-F2767BA58DE4_at_gmail.com>
doesn't seem to work:
Date: Mon, 16 Nov 2009 21:02:23 +0100
Message-Id: <6BF8FE23-CAF4-4FB6-A554-F2767BA58DE4_at_gmail.com>
doesn't seem to work:
2009-11-16 20:59:44 BERX_at_CDB111T11 > create table bla (n number);
Table created.
2009-11-16 21:00:14 BERX_at_CDB111T11 > create view bla as select * from
bla;
create view bla as select * from bla
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
how do you want to avoid the ORA-955 ?
> Is it possible to create a view with the same name as a table in the
> same schema without harming an application?
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 16 2009 - 14:02:23 CST