Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Obj = -2

Obj = -2

From: Anjo Kolk <anjo_at_oraperf.com>
Date: Wed, 15 Sep 2004 08:54:10 +0200
Message-Id: <200409150654.i8F6s6Ee001980@server.oraperf.com>


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.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 15 2004 - 01:49:44 CDT

Original text of this message

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