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

First of all, thank you (and other guys) for all your replies. I verified it -- that's a correct answer.

So, we know that objects with type 10 (in my schema) is: 1. objects referenced by my objects

   and, at the same time
2. have public synonyms
3. even if I drop my object (view v1 in Jonathan's example),

   reference to the t1 still remains in the obj$. At least for    some time, until SMON or PMON will purge them.

Tim

In article <926453356.1892.0.nnrp-02.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> '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
> someone else's schema. The validity of this
> view is dependent on the fact that there is
> no object named T1 in your schema; so
> Oracle creates a 'non-existent' object in
> your schema that the view can depend on.
>
> Then, when you create an object called T1 in
> your schema, this causes the elimination of
> the 'non-existent' object, which automatically
> causes the invalidation and recompilation of
> the view to use your table.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> tashepkov_at_my-dejanews.com wrote in message
<7h7m62$n3o$1_at_nnrp1.deja.com>...
> >Hello,
> >
> >Does anybody know what object with type 10 means in Oracle?
> >
> >It is a long story to tell why I am asking about it.
> >But, in short, we are running Oracle Parallel Server 8.0.5.1.1 on
> >OSF1 v4.0 and I think that Oracle data dictionary is corrupted.
> >(sometimes server dumps core with code ORA-0600 -- internal error).
> >
> >I looked at the source of sys.all_objects view and noticed that
> >objects with type 10 is just skipped in output of that view:
> >
> >...
> >
> > and (o.type# not in (1 /* INDEX - handled below */,
> > 10 /* NON-EXISTENT */)
> >...
> >
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 13:30:20 CDT