Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: Extracting data from longraw datatype
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