Re: Views and tables

From: Joey D'Antoni <>
Date: Mon, 16 Nov 2009 12:01:02 -0800 (PST)
Message-ID: <>

In the same schema I don't think Oracle will let you.

OPS$ORACLE_at_WCPPRD> create table test (a varchar2(20));

Table created.

OPS$ORACLE_at_WCPPRD> create view test as select * from test; create view test as select * from test

ERROR at line 1:
ORA-00955: name is already used by an existing object

Joseph D'Antoni
Synthes USA

From: J. Dex <> To:
Sent: Mon, November 16, 2009 2:45:41 PM
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.       
Received on Mon Nov 16 2009 - 14:01:02 CST

Original text of this message