RE: Views and tables

As many others pointed out, it's not possible.

If you take a moment to think about why, it's because tables, views, and 
private synonyms are all in the same namespace.

So, if you have a table BLAH, you cannot have a view or private synonym 'BLAH' 
in the same schema.

-Mark

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Steve Baldwin
Sent: Monday, November 16, 2009 3:06 PM
To: cemail_219@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Views and tables

Forget about harming an application, I don't believe *Oracle* will
allow a view and table of the same name.

Try it.  Create a dummy table and then a dummy view of the same name.

On Tue, Nov 17, 2009 at 6:45 AM, J. Dex <cemail_219@xxxxxxxxxxx> wrote:
> 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-l




--
http://www.freelists.org/webpage/oracle-l


Other related posts: