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 F ile S ystem 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
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.