Re: Views and tables

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: cemail_219@xxxxxxxxxxx
  • Date: Mon, 16 Nov 2009 21:02:23 +0100

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?

Other related posts: