Oracle DBMS_FS
Version 19.3

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 No
First Available 12.1.0
Security Model Owned by SYS with EXECUTE granted to the DBA role
Source {ORACLE_HOME}/rdbms/admin/dbmsfs.sql
Subprograms
 
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.

Related Topics
Built-in Functions
Built-in Packages
DBMS_APBACKEND
DBMS_DBFS_CONTENT
DBMS_DBFS_CONTENT_ADMIN
DBMS_DBFS_CONTENT_SPI
DBMS_DBFS_HS
DBMS_DBFS_SFS
DBMS_DBFS_SFS_ADMIN
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx