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: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 3 Dec 2006 16:55:13 -0800
Message-ID: <1165193713.402024.140980@16g2000cwy.googlegroups.com>

Sathish Bala wrote:
> 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.

You can look at the contents of the oracle database files directly. Received on Sun Dec 03 2006 - 18:55:13 CST

Original text of this message

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