Re: Strange: after TRUNCATE I noticed the obj# differs in a segment hdr dump

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Thu, 18 Sep 2003 18:48:58 +0200
Message-ID: <efojmvkt7k13295ibmpg9d7dcsrqss4dqo@4ax.com>

On 18 Sep 2003 07:57:14 -0700, spendius_at_muchomail.com (Spendius) wrote:

>I've noticed that the line
>> Map Header:: next 0x... #extents: 1 obj#: 23896 flag:...
>
>in a trace file (resulting from an ALTER SYSTEM DUMP DATAFILE
>command) changes and that the value of obj# is incremented (yet
>nothing's changed in SYS.OBJ$ or DBA_OBJECTS -fortunately-).
>
>Does anyone know where does this value come from/where it's
>stored ? (when I do SELECT name FROM sys.obj$ WHERE obj#=newValue
>I get "no rows selected")
>
>Thanks.

And of course no version included

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Sep 18 2003 - 11:48:58 CDT