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

Funny you should bring this up.

We have exactly the same problem. ORA600 crashes -- on all snapshot refreshes
and when I drop and recreate the snaphsot it fails with the "name aleady in use" erro and its there as a type 10!

We had a crash on Friday recovered and then upgraded to 815 from 805 on the Saturday and only found the problem on Monday so I am wondering which of the two events was responsible for this problem.

I was begiining to think it was catlog problem as well.....

Looking at the answers to your post has been a god send.

Why we got the 600 crash in the first place I dont know but I can see that once I dropped the snapshot the type 10 object was probably created to handle all the other views or queries that reference this snapshot. As someone said creating a "real" object ie a view or table is OK as it replaces the type 10 but it wont allow you to create a snapshot if the type 10 exists (same I guess for whatever yours was).

So I solved it by recreating the snapshots with a "1" appended to there name ie "DO_IT1" which works then create a synonym with the original snapshot name ie "DO_IT". This works as a synonym replaces the type 10, and then all my other views and queries work without a change.

Rob

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 */)
>...
>
>So, there is something in the data dictionary and server don't want
>to show it through "official" view.
>
>Anybody knows what that type 10 mean?
>
>Thank you,
>Tim Ashepkov
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Wed May 12 1999 - 02:04:54 CDT