Answer: How do I access Oracle B Filesby Snuggle (Friar)
|on Dec 06, 2001 at 05:00 UTC||Need Help??|
This question is pretty vauge, but here it goes...
In ORACLE, binary files are housed in a couple of different formats. LOB, BLOB, CLOB are all pretty much the same in that they hold the binary information in the database itself. BFiles are basically, as you said, pointers to files on the OS. I assume your question is that you want to populate a table with some BFiles, and not that you want to get the files actually on the database itself (BLOB).
Use of the function
BFILENAME(<directory handle>, '<filename>')
will return a handle to the bfile that you can then INSERT into the table. One thing about the <directory handle> parameter...
In your init.ora file in your Oracle Home you need to include the line
You then need to have give the directory a handle by using the following SQL:
You can check that the directory handle was made by:
It is this directory handle that you have to send to BFILENAME to tload the file pointer into the Database.