Re: Views and tables
From: Joey D'Antoni <jdanton1_at_yahoo.com>
Date: Mon, 16 Nov 2009 12:01:02 -0800 (PST)
Message-ID: <836537.45938.qm_at_web59008.mail.re1.yahoo.com>
In the same schema I don't think Oracle will let you.
From: J. Dex <cemail_219_at_hotmail.com> To: oracle-l_at_freelists.org
Sent: Mon, November 16, 2009 2:45:41 PM
Subject: Views and tables
Hotmail: Trusted email with powerful SPAM protection. Sign up now.
Date: Mon, 16 Nov 2009 12:01:02 -0800 (PST)
Message-ID: <836537.45938.qm_at_web59008.mail.re1.yahoo.com>
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 <cemail_219_at_hotmail.com> To: oracle-l_at_freelists.org
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 16 2009 - 14:01:02 CST