BFILE

From Oracle FAQ
Jump to: navigation, search

A BFILE is a data type used to store a locator (link) to an external binary file (file stored outside of the database). The maximum size for such file can be up to 4 GB (operating system specific). From an Oracle perspective, BFILEs are read-only and cannot be replicated to another system.

[edit] Example

CREATE TABLE files (fId NUMBER, fName BFILE);
CREATE DIRECTORY my_dir AS '/tmp';
INSERT INTO files VALUES (1, BFILENAME('MY_DIR', 'pic1.gif'));

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #