Re: Using DD to Read Data from Oracle Datafiles

Bernard,
I think he meant contents and not comments.

On 2/7/07, Polarski, Bernard <Bernard.Polarski_at_atosorigin.com> 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_at_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<http://us.rd.yahoo.com/mail/uk/taglines/default/security_centre/*http:/uk.security.yahoo.com/>
> .
>

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