Re: Views and tables
Date: Mon, 16 Nov 2009 12:01:02 -0800 (PST)
In the same schema I don't think Oracle will let you.
OPS$ORACLE_at_WCPPRD> create table test (a varchar2(20));
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
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. Received on Mon Nov 16 2009 - 14:01:02 CST