Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle Data Types - BFILE
Versions: Oracle 11g, 10g, 9i and 8i
| Oracle - BFILE | |
|---|---|
| Syntax | BFILE |
| Data | Pointer to a binary file that are stored in file systems outside Oracle Database. BFILE column stores a BFILE locator - the directory and the file name BFILE enables read-only operations. DBMS_LOB package or OCI API can be used to access BFILE data |
| Range | 264-1 bytes or restricted by operating system |
| Transactions | BFILE data do not participate in transactions and are not recoverable by Oracle, and the underlying operating system provides file integrity |
| Standards | Oracle Extension |
Oracle BFILE - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| MySQL | VARCHAR containing file path |
| PostgreSQL | VARCHAR containing file path |
| Sybase ASE | VARCHAR containing file path |
Related Data Types in Oracle
| Data Types | ||
|---|---|---|
| Variable-length binary data | BLOB | |
All Data Types