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 -> Re: Help Dumping a Block

Re: Help Dumping a Block

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 30 Nov 2006 16:59:48 -0800
Message-ID: <1164934785.255481@bubbleator.drizzle.com>


Brian Peasland 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.
>>
>> Thanks.

>
> If you're looking for just the binary data, then why not make a copy of
> the file and open it with a binary hex editor? I use xvi for this purpose:
>
> http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm
>
> This will get you the binary data of the file...you will just need to
> figure out the starting address of db block in question...based on the
> block size of course.
>
> Cheers!
> Brian

Because I have good reason to believe that there is some mechanism within Oracle to do what I want ... and I want only one specific block.

-- 
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 Thu Nov 30 2006 - 18:59:48 CST

Original text of this message

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