Re: Loading bfiles into blob.............
Date: Tue, 20 Mar 2001 14:45:17 +0200
Message-ID: <997jcv$1pjp$1_at_ID-75577.news.dfncis.de>
Hi,
You can do it by uploading table and loading it again into table with BLOB. You can write your own tool or use our tool Chyfo (www.ispirer.com/chyfo.html) that can help you in this.
It uploads a table to CSV (with locators for BFILE), generates contol file for SQLLoader (with FILLER-LOBFILE option for loading into LOBs). You have to run generated scripts only.
Contact me support_at_ispirer.com for details.
Best regards, Dmitry Tolpeko.
"P?l Jakobsen" <paal.jak_at_nl.telia.no> wrote in message
news:HWtt6.61$6Sc.170760192_at_news.telia.no...
> Anyone knows how to load several bfiles from a server catalog into a table
> in the database without knowing the filenames (only the catalog is known).
> These files will be Acrobat *.pdf files automatically produced in a
> production system and the file names can varying a lot. To make any
control
> file in advance will be to time consuming and I am looking for a way to
> upload all the files which exist in the catalog with a sequencer to
deliver
> the primary key.
>
> I have installed 8.1.7 with the Intermedia option.
>
> thanks
>
>
Received on Tue Mar 20 2001 - 13:45:17 CET