Re: Help Dumping a Block

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 03 Dec 2006 17:43:20 -0800
Message-ID: <1165196598.428410@bubbleator.drizzle.com>

hpuxrac wrote:

> DA Morgan wrote:

>> Does anyone know how to dump an Oracle block as just the binary
>> data without formatting or commenting as part of the process?
>>
>> ALTER SYSTEM DUMP DATAFILE 6 BLOCK 21229;
>>
>> Is not what I need.
>>

>
> Use the unix dd command.

How would you use that to extract a single known block?

Say, for example, the block referred to in this query?

SELECT album, dbms_rowid.rowid_to_absolute_fno(rowid, 'UWCLASS', 'BOWIE_STUFF') ABSOLUTE_FNO, dbms_rowid.rowid_block_number(rowid) BLOCKNO, dbms_rowid.rowid_row_number(rowid) ROWNUMBER FROM bowie_stuff
WHERE album LIKE '%Dogs%';

ALBUM                          ABSOLUTE_FNO BLOCKNO    ROWNUMBER
------------------------------ ------------ ---------- ----------
Diamond Dogs                              6       8586          1

File number 6 is easy to find. But how would I find block 8586 with dd?

Any help will be sincerely appreciated.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Dec 03 2006 - 19:43:20 CST