Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Non-existing objects? (sys.obj$.type# = 10)

Re: Non-existing objects? (sys.obj$.type# = 10)

From: Ross Mohan <postmaster_at_127.0.0.1>
Date: Tue, 11 May 1999 23:25:43 -0400
Message-ID: <7harmj$igi@sjx-ixn10.ix.netcom.com>


And the fact that you have to check for this each time you reference the object when a public synonym exists is a bad perf hit....down with public synonyms....

Jonathan Lewis wrote in message
<926453356.1892.0.nnrp-02.9e984b29_at_news.demon.co.uk>...
>'Non-existent' objects exist to handle
>'negative dependency' tracking.
>
>Say you have a view
>
> create or replace view v1 as
> select * from t1;
>
>but T1 is actually a public synonym to a table in
Received on Tue May 11 1999 - 22:25:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US