Oracle | DBMS

Oracle DBMS_FS Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Oracle File System operations definition.

AUTHID CURRENT_USER

Dependencies

OFSDTAB$

OFSMTAB$

OFSOTAB$

Documented Yes: Packages and Types Reference

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbmsfs.sql

Subprograms

DESTROY_ORACLE_FS	MOUNT_ORACLE_FS	UNMOUNT_ORACLE_FS
MAKE_ORACLE_FS

DESTROY_ORACLE_FS

Drops a file system of type specified by file system type and name similar to mkfs on Unix dbms_fs.destroy_oracle_fs( fstype IN VARCHAR2, fsname IN VARCHAR2);

exec dbms_fs.destroy_oracle_fs('FUBAR', 'FUBAR');

MAKE_ORACLE_FS

Creates a file system of type specified by file system type and name similar to mkfs on Unix dbms_fs.make_oracle_fs( fstype IN VARCHAR2, fsname IN VARCHAR2, fsoptions IN VARCHAR2); -- comma separated file system create options

exec dbms_fs.make_oracle_fs('FUBAR', 'FUBAR', 'FUBAR');

      

      The fact that this runs successfully, and there are no dependencies, unfortunately tells us nothing about it.

MOUNT_ORACLE_FS

Mount an Oracle file system on the specified mount point similar to mount in Unix dbms_fs.mount_oracle_fs ( fstype IN VARCHAR2, fsname IN VARCHAR2, mount_point IN VARCHAR2, mount_options IN VARCHAR2);

exec dbms_fs.mount_oracle_fs('FUBAR', 'FUBAR', '/fubar', 'FUBAR');

      

      -- Doing this hang the session and the system ... SYSDBA can log on but a SHUTDOWN IMMEDIATE does not work forcing an ABORT.

UNMOUNT_ORACLE_FS

Unmount an Oracle file system on the specified mount point similar to umount in Unix dbms_fs.unmount_oracle_fs( fsname IN VARCHAR2, mount_point IN VARCHAR2);

exec dbms_fs.unmount_oracle_fs('FUBAR',  '/fubar');

      

      -- Doing this hang the session and the system ... SYSDBA can log on but a SHUTDOWN IMMEDIATE does not work forcing an ABORT.