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: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 1 Dec 2006 07:09:36 +0100
Message-ID: <456fc726$0$15490$426a74cc@news.free.fr> 






"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
Received on Fri Dec 01 2006 - 00:09:36 CST












Original text of this message













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