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 -> Re: Mass load of BLOBs

Re: Mass load of BLOBs

From: Mark Townsend <markbtownsend_at_home.com>
Date: Sat, 01 Sep 2001 02:44:01 GMT
Message-ID: <B7B59981.ED25%markbtownsend@home.com>


in article 3b8f675c_at_news.iprimus.com.au, Howard J. Rogers at howardjr_at_www.com wrote on 8/31/01 3:35 AM:

> Any one got a PL/SQL procedure that would scan the contents of D:\PhotoAlbum
> and load into a table ALBUM contain a single column PHOTO (blob)?
>
> Sorry, but my PL/SQL's not up to it, and I'm not going to sit there
> inserting all 10,000 photos one-by-one!
>
> Regards
> HJR
>
>
>
>

The SQLLoader example already given in this thread will work - but if you are just wanting to store the photos with some extra data attributes, have you considered firing up iFS ? Then you can drag and drop the photo's to an iFS folder in Explorer (or FTP them), access and/or upload using a browser, and iFS will auto-extract the metadata (Date, Format, Size etc) for you and allow you to search across this information. You can also extend the metadata to add your own attributes. You also get foldering and version management.

I know of one company (guess who) that has close to 3 TB of documents and multimedia in a single iFS database, supporting the web publishing needs of over 40,000 people, and it's working a treat. Received on Fri Aug 31 2001 - 21:44:01 CDT

Original text of this message

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