doesn't seem to work: 2009-11-16 20:59:44 BERX@CDB111T11 > create table bla (n number); Table created.2009-11-16 21:00:14 BERX@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?