RE: Using DD to Read Data from Oracle Datafiles

I think this is the funniest request of this starting year, and deserve a price:

I grant you the 'Jack Vance' special prize for your imagination and the right to bear the nick name 'Nagimiraz the marvelous'  

Anyhow comments will be stored in the data dictionary which is in tablespace system  

Bernard Polarski  

From: Naqi Mirza [mailto:naqimirza_at_yahoo.com] Sent: woensdag 7 februari 2007 9:16
To: oracle-l
Subject: Using DD to Read Data from Oracle Datafiles  

Hi,
I am using dd to read data out of oracle datafiles from an oracle 9i database on solaris. I am using the following command:

dd if=/location_to_oracle_datafile_and_file_name.DBF bs=8192 skip=11764 count=8 | strings

I have a table called DEPT, querying dba_extents, I see that its block_id is 11764. It also have 8 blocks assigned to it. Now using the above, I get the following output:

OPERATIONS
BOSTON,
SALES
CHICAGO,
RESEARCH
DALLAS,
ACCOUNTING
NEW YORK Whats missing from here is numeric values. Since I am piping the output to strings , strings will not print out numerics. Does anyone know how i can use the method above to successfully read an entire table and print out all its comments.
Thanks.  

To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre
<http://us.rd.yahoo.com/mail/uk/taglines/default/security_centre/*http:/ uk.security.yahoo.com/> .

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