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.