Oracle DBFS Client/Server
- The Oracle Database File System (DBFS) creates a standard file system interface on top of the files and directories that are stored in database tables.
- In order to create the file system, you have to run the script $ORACLE_HOME/rdbms/admin/dbfs_create_filesystem.sql and perform some configuration.
- DBFS is similar to NFS in that it provides a shared network file system that looks like a local file system.
- Like NFS, there is a server component and a client component.
In DBFS, the server is the Oracle Database:
Files are stored as Secure Files LOBs in a database table.
A set of PL/SQL procedures implements the file system access privileges such as create, open, read, write, and list directory.
Oracle DBFS Content Store
The implementation of the file system in the database is called the DBFS Content Store.
The DBFS Content Store allows each database user to create one or more file systems that can be mounted by clients.
Each file system has its own dedicated tables that hold the file system content.
DBFS also has a client component that runs on each file system client machine called dbfs_client.
dbfs_client provides a command-line interface to allow files to be easily copied to and from the database from any host on the network.
It implements simple file system commands such as list and copy, which are similar to the shell utilities ls and rcp.
Oracle 12c introduces the following access:
HTTP/HTTPS, FTP and WebDAV (Access to the DBFS is via the “/dbfs” virtual directory in the XML DB repository).
The HTTP access to the database can be configured to use Digest Authentication.
Reference MOS: 1054431.1 – Configuring DBFS on Oracle Exadata Database Machine