| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Oracle File System operations definition. |
| AUTHID |
CURRENT_USER |
| Data Types |
TYPE listdir_entry_t IS RECORD(
obj_pathname VARCHAR2(1024),
obj_size INTEGER,
obj_ctime NUMBER(20),
obj_mtime NUMBER(20));
TYPE listdir_entires_t IS TABLE OF listdir_entry_t; |
| Dependencies |
|
| Documented |
Yes: Packages and Types Reference |
| First Available |
12.1 |
| Pragmas |
PRAGMA TIMESTAMP('2011-02-14:12:00:00'); |
| 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'); |
| |
| FS_EXISTS |
| Returns 1 if file system exists, 0 if not |
dbms_fs.fs_exists(fsname IN VARCHAR2) RETURN INTEGER; |
| TBD |
| |
| LIST_FILES |
| Provides all available file details present within a directory or subdirectories |
dbms_fs.list_files(objdir_path IN VARCHAR2) RETURN listdir_entries_t PIPELINED; |
| TBD |
| |
| 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. |