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@xxxxxxxxx] 
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/> .

Other related posts: