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: Sathish Bala <x_at_x.com>
Date: Sun, 03 Dec 2006 19:49:46 -0500
Message-ID: <WPadnYl5Obh08u7YnZ2dnUVZ_uGdnZ2d@comcast.com>


Michel Cadot wrote:
> "DA Morgan" <damorgan_at_psoug.org> a écrit dans le message de 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.
> |
> | Thanks.
> | --
> | 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
>
> Alter session set events '10289 trace name context forever, level 1';
> Alter system dump datafile &File block min &BlockMin block max &BlockMax;
> Alter session set events '10289 trace name context off';
>
> Regards
> Michel Cadot
>
>

What can be accomplished doing this? It is a question out of curiosity more to the OP. Received on Sun Dec 03 2006 - 18:49:46 CST

Original text of this message

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