Re: Lobs

BLOB or BFILE?

If the data is to be stored in the database, then you need to use a BLOB. BFILEs are simply a "pointer" to file which resides outside of the database files. BFILEs allow access the external files from within the database, but are not protected by the database (backups/transactions) etc.

If the files to be stored are accessible on the same machine that the database is running on you can possibly use the DBMS_LOB package to load the files.

In article <3b0a524a$1_at_d2o21.telia.com>, "Roland Carlsson" <roland.c_at_swetravel.se> wrote:

> Hi!
> I've got the task to implement a way to store files in our database. But
> my success in finding out how to do this has been anything but
> sucessfull. I know that I should use a blob or bfile.. but I don't know
> how to get it into the database. For an example a textfile could have
> several ' in it so I think I have to use some pointer to the file or
> give the database an input stream to load from.... If not for any other
> reason that it would be quite strange queries to debugg with n kb of
> data in the middle of it....
>
> Could anyone please give me some pointers
>
> Many thanks in advance
> Roland Carlsson
>
>
Received on Mon May 28 2001 - 15:52:51 CDT