SQL>
SELECT dbms_rowid.rowid_block_numer(rowid) address_block
2
FROM your_table
3
WHERE column_name = ‘Your select condition.’
4
/
This
query will return the block number of the record that you
are
interested to see.
1652
Now
since you know the exact location of that record, do the
following
steps:
·
Add 8 more blocks
to that address (1652 + 8 = 1660).
·
Now, your record is
in block position 1660 on that data file.
·
Use dd command with
ibs parameter (block size) to skip 1660 block.
#
dd if=/u01/oradata/your_database/your_datafile.dbf ibs=8192 \
skip=1660
count=1|strings
We
strongly advise you not to use this.
Good
Luck!