Re: Help Dumping a Block

Jonathan Lewis wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1164919494.844221_at_bubbleator.drizzle.com...
> > 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.
> >
>
> alter session set events '10289 trace name context forever';
>
> --
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentals
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html

I ran across this page before seeing the posting by Jonathan Lewis: http://www.ixora.com.au/scripts/sql/hex_blockdump.sql

The output is interesting:
Start dump data blocks tsn: 4 file#: 4 minblk 56 maxblk 58 buffer tsn: 4 rdba: 0x01000038 (4/56)
scn: 0x0000.0119cdab seq: 0x01 flg: 0x04 tail: 0xcdab0601 frmt: 0x02 chkval: 0x8d71 type: 0x06=unknown Hex dump of block: st=0, typ_found=0
Dump of memory from 0x000000000F47C600 to 0x000000000F47E600

00F47C600 0000A206 01000038 0119CDAB 04010000  [....8...........]
00F47C610 00008D71 00000001 00002E4D 0119CDAB  [q.......M.......]
00F47C620 00000000 00320003 01000031 0012000A  [......2.1.......]
00F47C630 00000097 00000000 00000000 0000A000  [................]
00F47C640 0119C898 00000000 00000000 00000000  [................]
00F47C650 00000000 00000000 00000000 00000000  [................]

It looks like there may be some possibilities with ORADEBUG also?

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Nov 30 2006 - 16:24:42 CST