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

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.