User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
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