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 -> Non-existing objects? (sys.obj$.type# = 10)

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

From: <tashepkov_at_my-dejanews.com>
Date: Mon, 10 May 1999 22:21:57 GMT
Message-ID: <7h7m62$n3o$1@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 Mon May 10 1999 - 17:21:57 CDT

Original text of this message

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