BFILE
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
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.
Example
CREATE TABLE files (fId NUMBER, fName BFILE);
CREATE DIRECTORY my_dir AS '/tmp';
INSERT INTO files VALUES (1, BFILENAME('MY_DIR', 'pic1.gif'));
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 | # |
