Translate

Sunday 26 October 2014

How to Find ASM Block

Create Table & Insert Rows




  Find the Default Tablespace & Datafile




   


Find the ROWID





1.    

  
Find the Block Number where ROWID is stored





1.    Set the ASM Environment and run the find_block.pl






Run the dd command to generate the output





1.    

Interpret the Output











Download find_block.pl Script from below site 



References:



No comments:

Post a Comment