RE: Using DD to Read Data from Oracle Datafiles
- From: "Polarski, Bernard" <Bernard.Polarski@xxxxxxxxxxxxxx>
- To: <naqimirza@xxxxxxxxx>,"oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Feb 2007 09:40:55 +0100
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:
