Monday, 30 November 2015

Datafile Dump

SQL> select header_file, header_block from dba_segments where segment_name = 'ABC_I';
 
HEADER_FILE HEADER_BLOCK
----------- ------------
          5       289161
 
SQL> alter system dump datafile 5 block 289162;
 
System altered.


row#0[8019] flag: ------, lock: 0, len=17
col 0; len 3; (3):  43 42 41
col 1; len 3; (3):  47 46 45
col 2; len 6; (6):  01 44 69 02 00 00

No comments: