Obj = -2

  • From: "Anjo Kolk" <anjo@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 15 Sep 2004 08:54:10 +0200

Has any one seen (at least in Oracle10g) that the object# is -2 for certain
CR blocks of an object and not the real object or data object number and
knows why that is? The object in questions is a regular table and not a RBS
(which have an obj# of -1). You can see this by querying x$bh and see the
unsigned value -2 in x$bh.
 

Anjo.



--
//www.freelists.org/webpage/oracle-l

Other related posts: