Re: Views and tables
- From: Joey D'Antoni <jdanton1@xxxxxxxxx>
- To: cemail_219@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 16 Nov 2009 12:01:02 -0800 (PST)
In the same schema I don't think Oracle will let you.
OPS$ORACLE@WCPPRD> create table test (a varchar2(20));
Table created.
OPS$ORACLE@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 <cemail_219@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
