Oracle DBFS – Database File System

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

Share This

Muhammad Rawish Siddiqui

Master in Computer Science (Database Engineering) and PGD in Management Information System.
45+ Online Certifications, which includes EDRP (EC-Council Disaster Recovery Professional), Data Management, Security+, DBaaS - Cloud Certified Expert, Oracle Cloud Autonomous Database Specialist, Oracle Database Cloud Certified Professional, Oracle Cloud Infrastructure, OCP 7.3, 10g, 11g, 11i, R12, OCE/OCS 11i System Administration, Solaris, Linux and Real Application Cluster 10g, 11g, Oracle Autonomous Database, Real Application Cluster, Oracle Data Guard and Performance Tuning etc. .

Foremost interested areas include, Data Management, Oracle Databases and EBS Health Checks, Real Application Cluster, Disaster Recovery, GoldenGate and Oracle Cloud.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments