Re: Using DD to Read Data from Oracle Datafiles

that was a spelling mistake i didnt mean to say comments i meant the actual data stored in the table. thank you for the prize i accept.

----- Original Message ----
From: "Polarski, Bernard" <Bernard.Polarski@atosorigin.com>
To: naqimirza@yahoo.com; oracle-l <oracle-l@freelists.org>
Sent: Wednesday, 7 February, 2007 1:40:55 PM
Subject: RE: Using DD to Read Data from Oracle Datafiles




 
 

 

 

 


<!--
 _filtered {font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
text-decoration:underline;}
span.EmailStyle17
	{
font-family:Arial;
color:navy;}
 _filtered {
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
	{}
-->






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@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.
 










		
___________________________________________________________ 
Copy addresses and emails from any email account to Yahoo! Mail - quick, easy and free. http://uk.docs.yahoo.com/trueswitch2.html

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