Re: database table as file system

You could use iFS.

It allows you to map a network drive to store data in the Oracle database. Whilst the files are not quite stored as you requested, they are accessible in this way via a series of views.

You can also have a full directory structure (which your method precludes) and can also store other types of objects (e.g., files with additional attributes), although this needs a little coding.

If you need to modify the files programatically, there are a while load of methods available too.

Regards,

ETA. "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<f59ea.4469$Bq6.2398_at_fed1read02>...
> Monty wrote:
> > All, I have a client that has a requirement to put files (text
> > documents, bitmaps, excel spreadsheets) into an Oracle database from
> > desktop applications. For simplicity for the users what I want to
> > offer is a product that maps a network drive as a simple database
> > table containing, for example, the filename and the file (a blob),
> > giving the impression that the table is a disk drive.
> >
> > Is anyone aware of an existing commercial product that would enable me
> > to "copy files from the desktop to, for example, the H: drive" when
> > really what is being done is importing a file from the desktop to a
> > blob in a database table.
> >
> > Thank you
> > Monty
>
> Why "MUST" the files reside in an Oracle database?
> Why can't the files remain in/on the filesystem
> with just a "pointer" within the database?
Received on Thu Mar 20 2003 - 09:56:56 CET