Re: Views and tables
Date: Mon, 16 Nov 2009 21:02:23 +0100
doesn't seem to work:
2009-11-16 20:59:44 BERX_at_CDB111T11 > create table bla (n number);
2009-11-16 21:00:14 BERX_at_CDB111T11 > create view bla as select * from
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?