Re: Using DD to Read Data from Oracle Datafiles
- From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
- To: naqimirza@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Feb 2007 01:19:05 -0800 (PST)
>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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
