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.
The basis of the question is an undocumented package. I think I know
what it does. Now I am trying to back-track to a capability I didn't
know was in the database. Essentially it seems that it must run against
a pure binary blockdump that exactly matches, in size, the number of
bytes in a database 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 Sun Dec 03 2006 - 19:43:58 CST
