Bernard, I think he meant contents and not comments. On 2/7/07, Polarski, Bernard <Bernard.Polarski@xxxxxxxxxxxxxx> wrote:
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/> .