Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Non-existing objects? (sys.obj$.type# = 10)
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 Mon May 10 1999 - 17:21:57 CDT
![]() |
![]() |