Re: Using DD to Read Data from Oracle Datafiles

>Does anyone know how i can use [dd] to successfully read an entire table and print out all its comments.

Naqi

Oracle provides a really handy utility called "SQL". It knows how to find your data, and how to translate any type of data you may store into a legible representation. If you know which file and block you want to read from, you can use the ROWID to get all the rows from that block:

select * from dept d
where dbms_rowid.rowid_block_number(d.rowid) = 92143 -- insert your block number and dbms_rowid.rowid_relative_fno(d.rowid) = 7 -- and file number

You can look up DBMS_ROWID here: http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_rowid.htm#998104

HTH Regards Nigel

--
http://www.freelists.org/webpage/oracle-l