Wednesday, October 15, 2008

Check which blocks are used in a table

select distinct DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid)
from ETSDYN.ETPPRICE;