Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: Extracting data from longraw datatype

REPOST: Re: Extracting data from longraw datatype

From: Dmitry <support_at_ispirer.com>
Date: Fri, 25 Jan 2002 16:32:09 +0200
Message-ID: <6$--$%%%_$%___--_$@news.noc.cabal.int>


Hi,

Try migration tool Chyfo at www.ispirer.com/products. It can extract data from long columns and place data into separate files. This is command prompt tool. For example:

chyfo.exe /d=ora_db /u=usr /p=pwd /s=select long_col1 from tab1

Best regards, Dmitry

"Tony Ferrazzo" <tferrazz_at_optusnet.com.au> wrote in message news:3c500b12$0$16301$afc38c87_at_news.optusnet.com.au...
> Hi,
> A work colleague told they had a table on oracle 7.3.? that uses
> datatype longraw to store word ( I assume ms word) documents within the
> table. They are looking at upgrading the application to a web front end
and
> will need to extract the documents so they can be placed somewhere on the
> server with the appropriate web links to them.
>
> My question is how would one extract this data from the table. I am told
> there are around 200,000 documents stored in a 14gb table. Are there any
> special tools, commands to view, and or extract this info.
>
>
> Thanks in advance
>
> Tony Ferrazzo
> tferrazz_at_hotmail.com
>
>

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 08:32:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US