Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Mass load of BLOBs
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