REPOST: Extracting data from longraw datatype

From: Tony Ferrazzo <tferrazz_at_optusnet.com.au>
Date: Fri, 25 Jan 2002 00:22:00 +1100
Message-ID: <5$--$%%%_$$$$$_$-$@news.noc.cabal.int>

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

WAS CANCELLED BY =======: From: "Tony Ferrazzo" <tferrazz_at_optusnet.com.au> Control: cancel <3c500b12$0$16301$afc38c87_at_news.optusnet.com.au> Subject: cmsg cancel <3c500b12$0$16301$afc38c87_at_news.optusnet.com.au> Date: Sun, 27 Jan 2002 23:48:33 GMT Message-ID: <cancel.3c500b12$0$16301$afc38c87_at_news.optusnet.com.au> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!uni-erlangen.de!newsfeeds.belnet.be!news.belnet.be!newsfeed.media.kyoto-u.ac.jp!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40725216

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 07:22:00 CST