How to dump data file blocks?

posted May 3, 2012, 7:13 PM by Sachchida Ojha   [ updated May 3, 2012, 7:14 PM ]


SQL>  alter system dump datafile <file_no> block <block_no>;

SQL> alter system dump datafile 1 block 110 ;

SQL> alter system dump datafile 4   block  min 120 block max 250;

SQL> alter system dump undo header '<segment name>';

Comments