Re: Mass load of BLOBs

I hang my head in a degree of shame and confess that whilst I've been intrigued by iFS, I've never experimented with it, and wonder whether Muggins here would ever be able to pull that particular trick off.

I know it's due. And I've just configured (sort of) a Linux box (gasp!) where I might play around with these sorts of things. But since I can't seem to pull off a 9i installation on the damn thing, I guess it may have to wait...

(My! This Windows 2000 is looking *awfully* easy in comparison).

Thanks for the advice, though. Much appreciated.

Regards
HJR "Mark Townsend" <markbtownsend_at_home.com> wrote in message news:B7B59981.ED25%markbtownsend_at_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 Sat Sep 01 2001 - 02:50:16 CDT