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