Oracle DBMS_DBFS_SFS
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose Store provider for the DBFS API, implementing the POSIX file system, and thus conforms to the DBFS SPI defined in "dbms_dbfs_content_spi".
AUTHID CURRENT_USER
Constants
Name Data Type Value
 Compression Parameters
compression_default VARCHAR2(32) ''
compression_low VARCHAR2(32) 'low'
compression_medium VARCHAR2(32) 'medium'
compression_high VARCHAR2(32) 'high'
 Encryption Parameters
encryption_default VARCHAR2(32) ''
encryption_3des168 VARCHAR2(32) '3DES168'
encryption_aes128 VARCHAR2(32) 'AES128'
encryption_aes192 VARCHAR2(32) 'AES192'
encryption_aes256 VARCHAR2(32) 'AES256'
 Partition Key Parameters
partition_by_item INTEGER 1
partition_by_path INTEGER 2
partition_by_guid INTEGER 3
 Partitions Parameters
default_partitions INTEGER 16
 sfs Properties
sfs_props_pts VARCHAR2(32) 'sfs:props:pts'
sfs_props_rootid VARCHAR2(32) 'sfs:props:rootid'
sfs_props_normid VARCHAR2(32) 'sfs:props:normid'
sfs_props_df VARCHAR2(32) 'sfs:props:df'
sfs_props_df_cache VARCHAR2(32) 'sfs:props:df_cache'
Data Types -- fastpath types
TYPE dir_entry_t IS RECORD (
path       VARCHAR2(1024), /* dbms_dbfs_content.path_t */
item_name  VARCHAR2(256), /* dbms_dbfs_content.name_t */
st_ino     INTEGER,
st_mode    INTEGER,
st_nlink   INTEGER,
st_uid     INTEGER,
st_gid     INTEGER,
st_size    INTEGER,
st_blksize INTEGER,
st_blocks  INTEGER,
st_atime   INTEGER,
st_mtime   INTEGER,
st_ctime   INTEGER,
st_atimens INTEGER,
st_mtimens INTEGER,
st_ctimens INTEGER);

TYPE dir_entries_t IS TABLE OF dir_entry_t;

-- dependent segments
TYPE dsegment_t IS RECORD (
schema       VARCHAR2(128),
segment_name VARCHAR2(128));

TYPE dsegments_t IS TABLE OF dsegment_t
INDEX BY PLS_INTEGER;

TYPE filesystem_t IS RECORD (
store_name    VARCHAR2(32),
schema_name   VARCHAR2(32),
table_name    VARCHAR2(32),
volume_name   VARCHAR2(128),
snapshot_name VARCHAR2(128),
created       TIMESTAMP);

TYPE filesystems_t IS TABLE OF filesystem_t;

TYPE propnames_t IS TABLE OF VARCHAR2(32);

TYPE snapshot_t IS RECORD (
schema_name   VARCHAR2(32),
table_name    VARCHAR2(32),
volume_name   VARCHAR2(128),
snapshot_name VARCHAR2(128),
created       TIMESTAMP);

TYPE snapshots_t IS TABLE OF snapshot_t;

TYPE table_t IS RECORD (
schema_name VARCHAR2(32),
table_name  VARCHAR2(32),
ptable_name VARCHAR2(32),
version#    VARCHAR2(32),
created     TIMESTAMP,
formatted   TIMESTAMP,
properties  sys.dbms_dbfs_content_properties_t);

TYPE tables_t IS TABLE OF table_t;

TYPE volume_t IS RECORD (
schema_name   VARCHAR2(32),
table_name    VARCHAR2(32),
volume_name   VARCHAR2(128),
created       TIMESTAMP,
from_volume   VARCHAR2(128),
from_snapshot VARCHAR2(128));

TYPE volumes_t IS TABLE OF volume_t;
Dependencies
ALL_CONSTRAINTS DBFS_SFS$_TAB DBMS_LOB
ALL_INDEXES DBFS_SFS$_VOL DBMS_PDB_IS_VALID_PATH
ALL_NESTED_TABLES DBMS_ASSERT DBMS_REDEFINITION
ALL_OBJECTS DBMS_DBFS_CONTENT DBMS_SQL
ALL_PROCEDURES DBMS_DBFS_CONTENT_CONTEXT_T DBMS_STANDARD
ALL_TABLES DBMS_DBFS_CONTENT_LIST_ITEMS_T DBMS_TYPES
ALL_TAB_COLS DBMS_DBFS_CONTENT_LIST_ITEM_T DIR_ENTRIES_T
ALL_TAB_PARTITIONS DBMS_DBFS_CONTENT_PROPERTIES_T DUAL
ALL_VIEWS DBMS_DBFS_CONTENT_PROPERTY_T PLITBLM
DBFS_OFS_CONVERSION DBMS_DBFS_CONTENT_RAW_T USER_CONSTRAINTS
DBFS_SFS$_FS DBMS_DBFS_HS USER_INDEXES
DBFS_SFS$_FST DBMS_DBFS_SFS_ADMIN USER_IND_COLUMNS
DBFS_SFS$_FSTO DBMS_DB_VERSION USER_TABLES
DBFS_SFS$_FSTP DBMS_FUSE UTL_RAW
DBFS_SFS$_SNAP DBMS_FUSE_PUBLIC  
Documented Yes: Packages and Types Reference
Exceptions
Error Code Reason
ORA-64007 Invalid Store Specified
First Available 11.2
Security Model Owned by SYS with EXECUTE granted to the  DBFS_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmsfspi.sql
Subprograms
ADDFSPROPERTIES FS_FTRUNCATE INITFSAUX
APPEND FS_GETATTR ISPATHLOCKED
CHECKACCESS FS_GETXATTR LIST
CLEANUPORPHANS FS_INIT LISTCURSOR
CREATEDIRECTORY FS_LINK LISTFILESYSTEMS
CREATEDIRECTORYAUX FS_LISTXATTR LISTSNAPSHOTS
CREATEFILE FS_MKDIR LISTTABLES
CREATEFILEAUX FS_MKDIRI LISTVOLUMES
CREATEFILESYSTEM FS_MKNOD LOCKPATH
CREATEFILESYSTEMAUX FS_MKNODOP LOCKPATHAUX
CREATEGETATTRVIEW FS_MKSOC MOVEPATH
CREATELINK FS_OPEN NORMALIZEFS
CREATELINKAUX FS_OPENAUX PURGEALL
CREATEREFERENCE FS_OPENDIR PURGEALLLOCKS
CREATEREFERENCEAUX FS_READ PURGELOCKSBYLOCKER
CREATESNAPSHOT FS_READDIR PURGELOCKSBYLOCKERAUX
CREATESTORE FS_READLINK PURGELOCKSBYPATH
DELETECONTENT FS_RELEASE PURGEPATH
DELETECONTENTAUX FS_RELEASEDIR PUTPATH
DELETEDIRECTORY FS_REMOVEXATTR RECREATEGETATTRVIEW
DELETEDIRECTORYAUX FS_RENAME RECREATEOLDGETATTRVIEW
DELETEFILE FS_RMDIR REGISTERFILESYSTEM
DELETEFILEAUX FS_RMDIRI REGISTERFILESYSTEMAUX
DELETEFSPROPERTIES FS_SETXATTR RENAMEPATH
DROPFILESYSTEM FS_STATFS RENAMEPATHAUX
DROPGETATTRVIEW FS_SYMLINK REORGANIZEFS
DROPSNAPSHOT FS_TRUNCATE RESTOREALL
EXPORTFILESYSTEM FS_UNLINK RESTOREPATH
EXPORTTABLE FS_UNLINKOP REVERTSNAPSHOT
FS_ACCESS FS_UTIME SEARCH
FS_CHMOD FS_UTIMEAUX SETFSPROPERTIES
FS_CHMODAUX FS_WRITE SETPATH
FS_CHOWN GETFEATURES SHRINKFS
FS_CHOWNAUX GETPATH SPACEUSAGE
FS_CREAT GETPATHBYSTOREID SPACEUSAGEFULL
FS_DESTROY GETPATHNOWAIT TO_EPOCH
FS_FGETATTR GETSTOREID UNLOCKPATH
FS_FLUSH GETVERSION UNLOCKPATHAUX
FS_FSYNC GET_EPOCH UNREGISTERFILESYSTEM
FS_FSYNCDIR INITFS  
 
ADDFSPROPERTIES
Adds properties to a POSIX store dbms_dbfs_sfs.addFSProperties(
store_name IN VARCHAR2,
properties IN sys.dbms_dbfs_content_properties_t);
TBD
 
APPEND
Undocumented dbms_dbfs_sfs.append(
buf IN OUT NOCOPY CLOB,
txt IN            VARCHAR2);
TBD
 
CHECKACCESS
Check if a given pathname (store_name, path, pathtype) can be manipulated by "operation (see the various "dbms_dbfs_content.op_xxx" opcodes) by "principal") dbms_dbfs_sfs.checkAccess(
store_name IN VARCHAR2,
path       IN VARCHAR2,
pathtype   IN INTEGER,
operation  IN VARCHAR2,
principal  IN VARCHAR2)
RETURN INTEGER;
TBD
 
CLEANUPORPHANS
Runs like DDL with double commits and drops orphaned POSIX stores dbms_dbfs_sfs.cleanUpOrphans(
schema_name IN VARCHAR2 DEFAULT NULL,
table_name  IN VARCHAR2 DEFAULT NULL);
exec dbms_dbfs_sfs.cleanUpOrphans('UWCLASS', 'DOCSTORE');
 
CREATEDIRECTORY
Creates a directory IN an existing store dbms_dbfs_sfs.createDirectory(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
recurse    IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t);
TBD
 
CREATEDIRECTORYAUX
Undocumented dbms_dbfs_sfs.createDirectoryAux(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
recurse    IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t,
ctime      IN            TIMESTAMP);
TBD
 
CREATEFILE
Stores a BLOB as a file in an existing store at an existing "path" location dbms_dbfs_sfs.createFile(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
content    IN OUT NOCOPY BLOB,
prop_flags IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t);
TBD
 
CREATEFILEAUX
Undocumented dbms_dbfs_sfs.createFileAux(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
content    IN OUT NOCOPY BLOB,
prop_flags IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t,
ctime      IN            TIMESTAMP);
TBD
 
CREATEFILESYSTEM
Create a file system, schema, in an existing store dbms_dbfs_sfs.createFileSystem(
store_name      IN VARCHAR2,
schema_name     IN VARCHAR2 DEFAULT NULL,
tbl_name        IN VARCHAR2 DEFAULT NULL,
tbl_tbs         IN VARCHAR2 DEFAULT NULL,
lob_tbs         IN VARCHAR2 DEFAULT NULL,
use_bf          IN BOOLEAN  DEFAULT FALSE,
properties      IN sys.dbms_dbfs_content_properties_t DEFAULT NULL,
create_only     IN BOOLEAN  DEFAULT FALSE,
use_objects     IN BOOLEAN  DEFAULT FALSE,
with_grants     IN BOOLEAN  DEFAULT FALSE,
do_dedup        IN BOOLEAN  DEFAULT FALSE,
do_compress     IN BOOLEAN  DEFAULT FALSE,
compression     IN VARCHAR2 DEFAULT compression_default,
do_encrypt      IN BOOLEAN  DEFAULT FALSE,
encryption      IN VARCHAR2 DEFAULT encryption_default,
do_partition    IN BOOLEAN  DEFAULT FALSE,
npartitions     IN NUMBER   DEFAULT default_partitions,
partition_key   IN NUMBER   DEFAULT partition_by_item,
partition_guidi IN BOOLEAN  DEFAULT FALSE,
partition_pathi IN BOOLEAN  DEFAULT FALSE,
partition_prop  IN BOOLEAN  DEFAULT TRUE);
TBD
 
CREATEFILESYSTEMAUX
Undocumented dbms_dbfs_sfs.createFileSystemAux(
store_name      IN VARCHAR2,
schema_name     IN VARCHAR2  DEFAULT NULL,
tbl_name        IN VARCHAR2  DEFAULT NULL,
tbl_tbs         IN VARCHAR2  DEFAULT NULL,
lob_tbs         IN VARCHAR2  DEFAULT NULL,
use_bf          IN BOOLEAN   DEFAULT FALSE,
properties      IN sys.dbms_dbfs_content_properties_t DEFAULT NULL,
create_only     IN BOOLEAN   DEFAULT FALSE,
use_objects     IN BOOLEAN   DEFAULT FALSE,
with_grants     IN BOOLEAN   DEFAULT FALSE,
do_dedup        IN BOOLEAN   DEFAULT FALSE,
do_compress     IN BOOLEAN   DEFAULT FALSE,
compression     IN VARCHAR2  DEFAULT compression_default,
do_encrypt      IN BOOLEAN   DEFAULT FALSE,
encryption      IN VARCHAR2  DEFAULT encryption_default,
do_partition    IN BOOLEAN   DEFAULT FALSE,
npartitions     IN NUMBER    DEFAULT default_partitions,
partition_key   IN NUMBER    DEFAULT partition_by_item,
partition_guidi IN BOOLEAN   DEFAULT FALSE,
partition_pathi IN BOOLEAN   DEFAULT FALSE,
partition_prop  IN BOOLEAN   DEFAULT TRUE,
ctime           IN TIMESTAMP DEFAULT NULL);
TBD
 
CREATEGETATTRVIEW
Create a Fastpath lookup view dbms_dbfs_sfs.createGetAttrView(
store_name IN  VARCHAR2,
cts        IN  sys.dbms_dbfs_content_context_t,
view_name  OUT VARCHAR2);
TBD
 
CREATELINK
Undocumented dbms_dbfs_sfs.createLink(
store_name IN            VARCHAR2,
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t);
TBD
 
CREATELINKAUX
Undocumented dbms_dbfs_sfs.createLinkAux(
store_name IN            VARCHAR2,
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t,
ctime      IN            TIMESTAMP);
TBD
 
CREATEREFERENCE
Undocumented dbms_dbfs_sfs.createReference(
store_name IN            VARCHAR2,
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t);
TBD
 
CREATEREFERENCEAUX
Undocumented dbms_dbfs_sfs.createReferenceAux(
store_name IN            VARCHAR2,
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t,
ctime      IN            TIMESTAMP);
TBD
 
CREATESNAPSHOT
Creates a new snapshot on the specified store/volume dbms_dbfs_sfs.createSnapshot(
store_name IN VARCHAR2,
snap_name  IN VARCHAR2,
vol_name   IN VARCHAR2 DEFAULT 'main',
do_wait    IN BOOLEAN  DEFAULT TRUE);
TBD
 
CREATESTORE
Wrapper around createFilesystem dbms_dbfs_sfs.createStore(
store_name IN VARCHAR2,
tbl_name   IN VARCHAR2 DEFAULT NULL,
tbs_name   IN VARCHAR2 DEFAULT NULL,
use_bf     IN BOOLEAN  DEFAULT FALSE,
stgopts    IN VARCHAR2 DEFAULT '');
TBD
 
DELETECONTENT
Delete directory, file, link, and reference elements (subject to store feature support) dbms_dbfs_sfs.deleteContent(
store_name  IN VARCHAR2,
contentID   IN RAW,
filter      IN VARCHAR2,
soft_delete IN INTEGER,
ctx         IN sys.dbms_dbfs_content_context_t);
TBD
 
DELETECONTENTAUX
Undocumented dbms_dbfs_sfs.deleteContentAux(
store_name  IN VARCHAR2,
contentID   IN RAW,
filter      IN VARCHAR2,
soft_delete IN INTEGER,
ctx         IN sys.dbms_dbfs_content_context_t,
ctime       IN TIMESTAMP);
TBD
 
DELETEDIRECTORY
Deletes a directory and reference elements (subject to store feature support) dbms_dbfs_sfs.deleteDirectory(
store_name  IN VARCHAR2,
path        IN VARCHAR2,
filter      IN VARCHAR2,
soft_delete IN INTEGER,
recurse     IN INTEGER,
ctx         IN sys.dbms_dbfs_content_context_t);
TBD
 
DELETEDIRECTORYAUX
Undocumented dbms_dbfs_sfs.deleteDirectoryAux(
store_name  IN VARCHAR2,
path        IN VARCHAR2,
filter      IN VARCHAR2,
soft_delete IN INTEGER,
recurse     IN INTEGER,
ctx         IN sys.dbms_dbfs_content_context_t,
ctime       IN TIMESTAMP);
TBD
 
DELETEFSPROPERTIES
Deletes properties from a POSIX store dbms_dbfs_sfs.deleteFSProperties(
store_name IN VARCHAR2,
properties IN sys.dbms_dbfs_content_properties_t);
TBD
 
DELETEFILE
Deletes a file and reference elements (subject to store feature support) dbms_dbfs_sfs.deleteFile(
store_name  IN VARCHAR2,
path        IN VARCHAR2,
filter      IN VARCHAR2,
soft_delete IN INTEGER,
ctx         IN sys.dbms_dbfs_content_context_t);
TBD
 
DELETEFILEAUX
Undocumented dbms_dbfs_sfs.deleteFileAux(
store_name  IN VARCHAR2,
path        IN VARCHAR2,
filter      IN VARCHAR2,
soft_delete IN INTEGER,
ctx         IN sys.dbms_dbfs_content_context_t,
ctime       IN TIMESTAMP);
TBD
 
DROPFILESYSTEM
It is necessary to run dropFilesystem or unregisterFilesystem before a store table can be dropped
Overload 1		 dbms_dbfs_sfs.dropFileSystem(
schema_name IN VARCHAR2 DEFAULT NULL,
tbl_name    IN VARCHAR2);
TBD
Overload 2 dbms_dbfs_sfs.dropFileSystem(store_name IN VARCHAR2);
exec dbms_dbfs_sfs.dropFilesystem('UWSTORE');
 
DROPGETATTRVIEW
Drops a Fastpath lookup view dbms_dbfs_sfs.dropGetAttrView(
store_name IN VARCHAR2,
view_name  IN VARCHAR2);
TBD
 
DROPSNAPSHOT
Drops the specified snapshot from the specified store/volume dbms_dbfs_sfs.dropSnapshot(
store_name IN VARCHAR2,
snap_name  IN VARCHAR2,
vol_name   IN VARCHAR2 DEFAULT 'main',
do_wait    IN BOOLEAN  DEFAULT TRUE,
recurse    IN BOOLEAN  DEFAULT FALSE);
TBD
 
EXPORTFILESYSTEM
Export a file system (for general cross-schema use) by granting suitable permissions to the tables underlying the file system to the "dbfs_role" dbms_dbfs_sfs.exportFileSystem(
store_name IN VARCHAR2,
toUserRole IN VARCHAR2 DEFAULT 'DBFS_ROLE');
TBD
 
EXPORTTABLE
Export a table (for general cross-schema use) by granting suitable permissions to the tables underlying the file system to the "dbfs_role" dbms_dbfs_sfs.exportTable(
schema_name IN VARCHAR2 DEFAULT NULL,
tbl_name    IN VARCHAR2,
toUserRole  IN VARCHAR2 DEFAULT 'DBFS_ROLE');
TBD
 
FS_ACCESS
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_Access(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN sys.dbms_dbfs_content_context_t,
path    IN VARCHAR2,
st_mode IN NUMBER)
RETURN INTEGER;
TBD
 
FS_CHMOD
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_ChMod(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN sys.dbms_dbfs_content_context_t,
path    IN VARCHAR2,
st_mode IN NUMBER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_ChMod(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
st_mode     IN  NUMBER,
ret_ino     OUT NUMBER,
ret_mode    OUT NUMBER,
ret_nlink   OUT NUMBER,
ret_uid     OUT NUMBER,
ret_gid     OUT NUMBER,
ret_size    OUT NUMBER,
ret_blksize OUT NUMBER,
ret_blocks  OUT NUMBER,
ret_atime   OUT NUMBER,
ret_mtime   OUT NUMBER,
ret_ctime   OUT NUMBER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_CHMODAUX
Undocumented

Overload 1		 dbms_dbfs_sfs.fs_chmodAux(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN sys.dbms_dbfs_content_context_t,
path    IN VARCHAR2,
st_mode IN INTEGER,
ctime   IN TIMESTAMP);
TBD
Overload 2 dbms_dbfs_sfs.fs_chmodAux(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
st_mode     IN  INTEGER,
ret_into    OUT NUMBER,
ret_mode    OUT NUMBER,
ret_nlink   OUT NUMBER,
ret_uid     OUT NUMBER,
ret_gid     OUT NUMBER,
ret_size    OUT NUMBER,
ret_blksize OUT NUMBER,
ret_blocks  OUT NUMBER,
ret_atime   OUT NUMBER,
ret_mtime   OUT NUMBER,
ret_ctime   OUT NUMBER,
ret_atimens OUT NUMBER,
ret_mtimens OUT NUMBER,
ret_ctimens OUT NUMBER,
ctime       IN  TIMESTAMP);
TBD
 
FS_CHOWN
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_ChOwn(
store  IN VARCHAR2,
mount  IN VARCHAR2,
ctx    IN sys.dbms_dbfs_content_context_t,
path   IN VARCHAR2,
st_uid IN NUMBER,
st_gid IN NUMBER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_ChOwn(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
st_uid      IN  NUMBER,
st_gid      IN  NUMBER,
ret_ino     OUT NUMBER,
ret_mode    OUT NUMBER,
ret_nlink   OUT NUMBER,
ret_uid     OUT NUMBER,
ret_gid     OUT NUMBER,
ret_size    OUT NUMBER,
ret_blksize OUT NUMBER,
ret_blocks  OUT NUMBER,
ret_atime   OUT NUMBER,
ret_mtime   OUT NUMBER,
ret_ctime   OUT NUMBER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_CHOWNAUX
Undocumented

Overload 1		 dbms_dbfs_sfs.fs_chownAux(
store  IN VARCHAR2,
mount  IN VARCHAR2,
ctx    IN sys.dbms_dbfs_content_context_t,
path   IN VARCHAR2,
st_uid IN INTEGER,
st_gid IN INTEGER,
ctime  IN TIMESTAMP);
TBD
Overload 2 dbms_dbfs_sfs.fs_chownAux(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
st_uid      IN  NUMBER,
st_gid      IN  NUMBER,
ret_ino     OUT NUMBER,
ret_mode    OUT NUMBER,
ret_nlink   OUT NUMBER,
ret_uid     OUT NUMBER,
ret_gid     OUT NUMBER,
ret_size    OUT NUMBER,
ret_blksize OUT NUMBER,
ret_blocks  OUT NUMBER,
ret_atime   OUT NUMBER,
ret_mtime   OUT NUMBER,
ret_ctime   OUT NUMBER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
ctime  IN TIMESTAMP);
TBD
 
FS_CREAT
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_creat(
store   IN         VARCHAR2,
mount   IN         VARCHAR2,
ctx     IN         sys.dbms_dbfs_content_context_t,
path    IN         VARCHAR2,
st_mode IN         NUMBER,
content OUT NOCOPY BLOB,
st_uid  IN         NUMBER,
st_gid  IN         NUMBER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_creat(
store       IN         VARCHAR2,
store       IN         VARCHAR2,
mount       IN         VARCHAR2,
ctx         IN         sys.dbms_dbfs_content_context_t,
path        IN         VARCHAR2,
st_mode     IN         NUMBER,
content     OUT NOCOPY BLOB,
st_uid      IN         NUMBER,
st_gid      IN         NUMBER,
ret_ino     OUT        NUMBER,
ret_mode    OUT        NUMBER,
ret_nlink   OUT        NUMBER,
ret_uid     OUT        NUMBER,
ret_gid     OUT        NUMBER,
ret_size    OUT        NUMBER,
ret_blksize OUT        NUMBER,
ret_blocks  OUT        NUMBER,
ret_atime   OUT        NUMBER,
ret_mtime   OUT        NUMBER,
ret_ctime   OUT        NUMBER,
ret_atimens OUT        INTEGER,
ret_mtimens OUT        INTEGER,
ret_ctimens OUT        INTEGER)
RETURN INTEGER;
TBD
 
FS_DESTROY
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_destroy RETURN INTEGER;
set serveroutput on

DECLARE
 retVal NUMBER;
BEGIN
  retVal := dbms_dbfs_sfs.FS_Destroy;
  dbms_output.put_line(TO_CHAR(retVal));
END;
/
 
FS_FGETATTR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_fGetAttr(
store      IN  VARCHAR2,
mount      IN  VARCHAR2,
ctx        IN  sys.dbms_dbfs_content_context_t,
path       IN  VARCHAR2,
st_ino     OUT NUMBER,
st_mode    OUT NUMBER,
st_nlink   OUT NUMBER,
st_uid     OUT NUMBER,
st_gid     OUT NUMBER,
st_size    OUT NUMBER,
st_blksize OUT NUMBER,
st_blocks  OUT NUMBER,
st_atime   OUT NUMBER,
st_mtime   OUT NUMBER,
st_ctime   OUT NUMBER,
st_atimens OUT INTEGER,
st_mtimens OUT INTEGER,
st_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_FLUSH
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_flush(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_FSYNC
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_FSync(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_FSYNCDIR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_fSyncDir(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_FTRUNCATE
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_FTruncate(
store   IN            VARCHAR2,
mount   IN            VARCHAR2,
ctx     IN            sys.dbms_dbfs_content_context_t,
path    IN            VARCHAR2,
newlen  IN            NUMBER,
content IN OUT NOCOPY BLOB)
RETURN INTEGER;
TBD
 
FS_GETATTR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_GetAttr(
store      IN  VARCHAR2,
mount      IN  VARCHAR2,
ctx        IN  sys.dbms_dbfs_content_context_t,
path       IN  VARCHAR2,
st_ino     OUT INTEGER,
st_mode    OUT INTEGER,
st_nlink   OUT INTEGER,
st_uid     OUT INTEGER,
st_gid     OUT INTEGER,
st_size    OUT INTEGER,
st_blksize OUT INTEGER,
st_blocks  OUT INTEGER,
st_atime   OUT INTEGER,
st_mtime   OUT INTEGER,
st_ctime   OUT INTEGER,
st_atimens OUT INTEGER,
st_mtimens OUT INGEGER,
st_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_GETXATTR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.getXAttr(
store  IN         VARCHAR2,
mount  IN         VARCHAR2,
ctx    IN         sys.dbms_dbfs_content_context_t,
path   IN         VARCHAR2,
xname  IN         VARCHAR2,
xvalue OUT NOCOPY RAW)
RETURN INTEGER;
TBD
 
FS_INIT
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_init RETURN INTEGER;
SELECT dbms_dbfs_sfs.fs_init;
 
FS_LINK
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_link(
store  IN VARCHAR2,
mount  IN VARCHAR2,
ctx    IN sys.dbms_dbfs_content_context_t,
path   IN VARCHAR2,
link   IN VARCHAR2,
st_uid IN INTEGER,
st_gid IN INTEGER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_link(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
link        IN  VARCHAR2,
st_uid      IN  INTEGER,
st_gid      IN  INTEGER,
ret_ino     OUT INTEGER,
ret_mode    OUT INTEGER,
ret_nlink   OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_size    OUT INTEGER,
ret_blksize OUT INTEGER,
ret_blocks  OUT INTEGER,
ret_atime   OUT INTEGER,
ret_mtime   OUT INTEGER,
ret_ctime   OUT INTEGER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_LISTXATTR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_listXAttr(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN propnames_t PIPELINED;
TBD
 
FS_MKDIR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_mkDir(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN sys.dbms_dbfs_content_context_t,
path    IN VARCHAR2,
st_mode IN INTEGER,
st_uid  IN INTEGER,
st_gid  IN INTEGER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_mkDir(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
st_mode     IN  INTEGER,
st_uid      IN  INTEGER,
st_gid      IN  INTEGER,
ret_ino     OUT INTEGER,
ret_mode    OUT INTEGER,
ret_nlink   OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_size    OUT INTEGER,
ret_blksize OUT INTEGER,
ret_blocks  OUT INTEGER,
ret_atime   OUT INTEGER,
ret_mtime   OUT INTEGER,
ret_ctime   OUT INTEGER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_MKDIRI
Undocumented dbms_dbfs_sfs.fs_mkDiri(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
st_mode     IN  INTEGER,
st_uid      IN  INTEGER,
st_gid      IN  INTEGER,
ret_mode    OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_ino     OUT INTEGER,
ret_ctime   OUT INTEGER,
ret_ctimens OUT INTEGER,
ctime       IN  TIMESTAMP);
TBD
 
FS_MKNOD
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_mkNod(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN sys.dbms_dbfs_content_context_t,
path    IN VARCHAR2,
st_mode IN INTEGER,
st_uid  IN INTEGER,
st_gid  IN INTEGER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_mkNod(
store       IN VARCHAR2,
mount       IN VARCHAR2,
ctx         IN sys.dbms_dbfs_content_context_t,
path        IN VARCHAR2,
st_mode     IN INTEGER,
st_uid      IN INTEGER,
st_gid      IN INTEGER,
ret_ino     OUT INTEGER,
ret_mode    OUT INTEGER,
ret_nlink   OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_size    OUT INTEGER,
ret_blksize OUT INTEGER,
ret_blocks  OUT INTEGER,
ret_atime   OUT INTEGER,
ret_mtime   OUT INTEGER,
ret_ctime   OUT INTEGER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_MKNODOP
Undocumented dbms_dbfs_sfs.fs_mkNodOp(
store       IN         VARCHAR2,
mount       IN         VARCHAR2,
ctx         IN         sys.dbms_dbfs_content_context_t,
path        IN         VARCHAR2,
st_mode     IN         INTEGER,
st_uid      IN         INTEGER,
st_gid      IN         INTEGER,
ptype       IN         INTEGER,
content     IN         BLOB,
target      IN         VARCHAR2,
rcontent    OUT NOCOPY BLOB,
ret_uid     OUT        INTEGER,
ret_gid     OUT        INTEGER,
ret_ino     OUT        INTEGER,
ret_ctime   OUT        INTEGER,
ret_ctimens OUT        INTEGER,
ctime       IN         TIMESTAMP);
TBD
 
FS_MKSOC
Undocumented

Overload 1		 dbms_dbfs_sfs.fs_mkSoc(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN sys.dbms_dbfs_content_context_t,
path    IN VARCHAR2,
st_mode IN INTEGER,
st_uid  IN INTEGER,
st_gid  IN INTEGER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_mkSoc(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
st_mode     IN  INTEGER,
st_uid      IN  INTEGER,
st_gid      IN  INTEGER,
ret_ino     OUT INTEGER,
ret_mode    OUT INTEGER,
ret_nlink   OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_size    OUT INTEGER,
ret_blksize OUT INTEGER,
ret_blocks  OUT INTEGER,
ret_atime   OUT INTEGER,
ret_mtime   OUT INTEGER,
ret_ctime   OUT INTEGER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_OPEN
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_open(
store    IN         VARCHAR2,
mount    IN         VARCHAR2,
ctx      IN         sys.dbms_dbfs_content_context_t,
path     IN         VARCHAR2,
content  OUT NOCOPY BLOB,
forWrite IN         INTEGER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_open(
store       IN         VARCHAR2,
mount       IN         VARCHAR2,
ctx         IN         sys.dbms_dbfs_content_context_t,
path        IN         VARCHAR2,
content     OUT NOCOPY BLOB,
forWrite    IN         INTEGER,
ret_ino     OUT        INTEGER,
ret_mode    OUT        INTEGER,
ret_nlink   OUT        INTEGER,
ret_uid     OUT        INTEGER,
ret_gid     OUT        INTEGER,
ret_size    OUT        INTEGER,
ret_blksize OUT        INTEGER,
ret_blocks  OUT        INTEGER,
ret_atime   OUT        INTEGER,
ret_mtime   OUT        INTEGER,
ret_ctime   OUT        INTEGER,
ret_atimens OUT        INTEGER,
ret_mtimens OUT        INTEGER,
ret_ctimens OUT        INTEGER)
RETURN INTEGER;
TBD
 
FS_OPENAUX
Undocumented

Overload 1		 dbms_dbfs_sfs.fs_openAux(
store    IN         VARCHAR2,
mount    IN         VARCHAR2,
ctx      IN         sys.dbms_dbfs_content_context_t,
path     IN         VARCHAR2,
content  OUT NOCOPY BLOB,
forWrite IN         INTEGER,
ctime    IN         TIMESTAMP);
TBD
Overload 2 dbms_dbfs_sfs.fs_openAux(
store       IN         VARCHAR2,
mount       IN         VARCHAR2,
ctx         IN         sys.dbms_dbfs_content_context_t,
path        IN         VARCHAR2,
content     OUT NOCOPY BLOB,
forWrite    IN         INTEGER,
ret_ino     OUT        INTEGER,
ret_mode    OUT        INTEGER,
ret_nlink   OUT        INTEGER,
ret_uid     OUT        INTEGER,
ret_gid     OUT        INTEGER,
ret_size    OUT        INTEGER,
ret_blksize OUT        INTEGER,
ret_blocks  OUT        INTEGER,
ret_atime   OUT        INTEGER,
ret_mtime   OUT        INTEGER,
ret_ctime   OUT        INTEGER,
ret_atimens OUT        INTEGER,
ret_mtimens OUT        INTEGER,
ret_ctimens OUT        INTEGER)
ctime       IN         TIMESTAMP);
TBD
 
FS_OPENDIR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_openDir(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_READ
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_read(
store   IN         VARCHAR2,
mount   IN         VARCHAR2,
ctx     IN         sys.dbms_dbfs_content_context_t,
path    IN         VARCHAR2,
buffer  OUT NOCOPY RAW,
amount  IN         INTEGER,
offset0 IN         INTEGER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_read(
store   IN         VARCHAR2,
mount   IN         VARCHAR2,
ctx     IN         sys.dbms_dbfs_content_context_t,
path    IN         VARCHAR2,
amount  IN         INTEGER,
offset0 IN         INTEGER,
buffers OUT NOCOPY dbms_dbfs_content_raw_t)
RETURN INTEGER;
TBD
 
FS_READDIR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_readDir(
store      IN VARCHAR2,
mount      IN VARCHAR2,
ctx        IN sys.dbms_dbfs_content_context_t,
path       IN VARCHAR2,
withProps  IN INTEGER,
doCursor   IN INTEGER,
doSort     IN INTEGER,
doFts      IN INTEGER,
doBulk     IN INTEGER,
doFallback IN INTEGER)
RETURN dbms_dbfs_sfs.dir_entries_t PIPELINED;
TBD
 
FS_READLINK
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_readLink(
store IN         VARCHAR2,
mount IN         VARCHAR2,
ctx   IN         sys.dbms_dbfs_content_context_t,
path  IN         VARCHAR2,
link  OUT NOCOPY VARCHAR2)
RETURN INTEGER;
TBD
 
FS_RELEASE
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_release(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_RELEASEDIR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_releaseDir(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_REMOVEXATTR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_removeXAttr(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2,
xname IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_RENAME
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_rename(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
opath IN VARCHAR2,
npath IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_RMDIR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_rmdir(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_RMDIRI
Undocumented dbms_dbfs_sfs.fs_rmDiri(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2,
ctime IN TIMESTAMP);
TBD
 
FS_SETXATTR
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_setXAttr(
store  IN VARCHAR2,
mount  IN VARCHAR2,
ctx    IN sys.dbms_dbfs_content_context_t,
path   IN VARCHAR2,
xname  IN VARCHAR2,
xvalue IN RAW,
xflags IN INTEGER)
RETURN INTEGER;
TBD
 
FS_STATFS
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_statFS(
store     IN  VARCHAR2,
mount     IN  VARCHAR2,
ctx       IN  sys.dbms_dbfs_content_context_t,
path      IN  VARCHAR2,
f_bsize   OUT INTEGER,
f_frsize  OUT INTEGER,
f_blocks  OUT INTEGER,
f_bfree   OUT INTEGER,
f_bavail  OUT INTEGER,
f_files   OUT INTEGER,
f_ffree   OUT INTEGER,
f_favail  OUT INTEGER,
f_fsid    OUT INTEGER,
f_flag    OUT INTEGER,
f_namemax OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_SYMLINK
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_symLink(
store  IN VARCHAR2,
mount  IN VARCHAR2,
ctx    IN sys.dbms_dbfs_content_context_t,
path   IN VARCHAR2,
link   IN VARCHAR2,
st_uid IN INTEGER,
st_gid IN INTEGER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_symLink(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
link        IN  VARCHAR2,
st_uid      IN  INTEGER,
st_gid      IN  INTEGER,
ret_ino     OUT INTEGER,
ret_mode    OUT INTEGER,
ret_nlink   OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_size    OUT INTEGER,
ret_blksize OUT INTEGER,
ret_blocks  OUT INTEGER,
ret_atime   OUT INTEGER,
ret_mtime   OUT INTEGER,
ret_ctime   OUT INTEGER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_TRUNCATE
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_truncate(
store  IN VARCHAR2,
mount  IN VARCHAR2,
ctx    IN sys.dbms_dbfs_content_context_t,
path   IN VARCHAR2,
newlen IN NUMBER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_truncate(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
newlen      IN  NUMBER,
ret_ino     OUT INTEGER,
ret_mode    OUT INTEGER,
ret_nlink   OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_size    OUT INTEGER,
ret_blksize OUT INTEGER,
ret_blocks  OUT INTEGER,
ret_atime   OUT INTEGER,
ret_mtime   OUT INTEGER,
ret_ctime   OUT INTEGER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_UNLINK
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly. dbms_dbfs_sfs.fs_unlink(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_UNLINKOP
Undocumented dbms_dbfs_sfs.fs_unlinkOp(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2,
ctime IN TIMESTAMP);
TBD
 
FS_UTIME
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_utime(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN sys.dbms_dbfs_content_context_t,
path  IN VARCHAR2,
atime IN INTEGER,
mtime IN INTEGER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_utime(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
atime       IN  INTEGER,
mtime       IN  INTEGER,
ret_ino     OUT INTEGER,
ret_mode    OUT INTEGER,
ret_nlink   OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_size    OUT INTEGER,
ret_blksize OUT INTEGER,
ret_blocks  OUT INTEGER,
ret_atime   OUT INTEGER,
ret_mtime   OUT INTEGER,
ret_ctime   OUT INTEGER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
 
FS_UTIMEAUX
Undocumented

Overload 1		 dbms_dbfs_sfs.fs_utimeAux(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN sys.dbms_dbfs_content_context_t,
path    IN VARCHAR2,
atime   IN INTEGER,
mtime   IN INTEGER,
atimens IN INTEGER,
mtimens IN INTEGER,
ctime   IN TIMESTAMP);
TBD
Overload 2 dbms_dbfs_sfs.fs_utimeAux(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
atime       IN  INTEGER,
mtime       IN  INTEGER,
atimens     IN  INTEGER,
mtimens     IN  INTEGER,
ret_ino     OUT INTEGER,
ret_mode    OUT INTEGER,
ret_nlink   OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_size    OUT INTEGER,
ret_blksize OUT INTEGER,
ret_blocks  OUT INTEGER,
ret_atime   OUT INTEGER,
ret_mtime   OUT INTEGER,
ret_ctime   OUT INTEGER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
ctime       IN  TIMESTAMP);
TBD
 
FS_WRITE
Fastpath operation for dbms_fuse/dbfs_client only. Do not use directly.

Overload 1		 dbms_dbfs_sfs.fs_write(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN sys.dbms_dbfs_content_context_t,
path    IN VARCHAR2,
buffer  IN RAW,
amount  IN INTEGER,
offset0 IN INTEGER)
RETURN INTEGER;
TBD
Overload 2 dbms_dbfs_sfs.fs_write(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
buffer      IN  RAW,
amount      IN  INTEGER,
offset0     IN  INTEGER,
ret_ino     OUT INTEGER,
ret_mode    OUT INTEGER,
ret_nlink   OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_size    OUT INTEGER,
ret_blksize OUT INTEGER,
ret_blocks  OUT INTEGER,
ret_atime   OUT INTEGER,
ret_mtime   OUT INTEGER,
ret_ctime   OUT INTEGER,
ret_atimens OUT INTEGER,
ret_mtimens OUT INTEGER,
ret_ctimens OUT INTEGER)
RETURN INTEGER;
TBD
Overload 3 dbms_dbfs_sfs.fs_write(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN sys.dbms_dbfs_content_context_t,
path    IN VARCHAR2,
offset0 IN INTEGER,
buffers IN dbms_dbfs_content_raw_t)
RETURN INTEGER;
TBD
Overload 4 dbms_dbfs_sfs.fs_write(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  sys.dbms_dbfs_content_context_t,
path        IN  VARCHAR2,
offset0     IN  INTEGER,
buffers     IN  dbms_dbfs_content_raw_t,
ret_ino     OUT INTEGER,
ret_mode    OUT INTEGER,
ret_nlink   OUT INTEGER,
ret_uid     OUT INTEGER,
ret_gid     OUT INTEGER,
ret_size    OUT INTEGER,
ret_blksize OUT INTEGER,
ret_blocks  OUT INTEGER,
ret_atime   OUT INTEGER,
ret_mtime   OUT INTEGER,
ret_ctime   OUT INTEGER)
RETURN INTEGER;
TBD
 
GETFEATURES
Lookup repository features (see dbms_content.feature_XXX) dbms_dbfs_sfs.getFeatures(store_name IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_dbfs_sfs.getFeatures('UWSTORE');
 
GETPATH
Returns a store's path

Overload 1		 dbms_dbfs_sfs.getPath(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
content       OUT NOCOPY BLOB,
item_type     OUT        INTEGER,
prop_flags IN            INTEGER,
forUpdate  IN            INTEGER,
deref      IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t);
TBD
Overload 2 dbms_dbfs_sfs.getPath(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
amount     IN OUT        NUMBER,
offset     IN            NUMBER,
buffer        OUT NOCOPY RAW,
prop_flags IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t);
TBD
Overload 3 dbms_dbfs_sfs.getPath(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
amount     IN OUT        NUMBER,
offset     IN            NUMBER,
buffers       OUT NOCOPY dbms_dbfs_content_raw_t,
prop_flags IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t);
TBD
 
GETPATHBYSTOREID
Lookup pathnames by (store_name, std_guid) or (store_mount, std_guid) tuples dbms_dbfs_sfs.getPathByStoreId(
store_name IN VARCHAR2,
guid       IN INTEGER)
RETURN VARCHAR2;
TBD
 
GETPATHNOWAIT
Implies a "forUpdate", and, if implemented (see "feature_nowait"), allows providers to RETURN an exception (ORA-54) rather than wait for row locks dbms_dbfs_sfs.getPathNoWait(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
content       OUT NOCOPY BLOB,
item_type     OUT        INTEGER,
prop_flags IN            INTEGER,
deref      IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t);
TBD
 
GETSTOREID
Returns a store ID which identifies a provider-specific store, across registrations and mounts, but independent of changes to the store contents dbms_dbfs_sfs.getStoreId(store_name IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_dbfs_sfs.getStoreID('UWSTORE');
 
GETVERSION
Returns a store's version dbms_dbfs_sfs.getVersion(store_name IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_dbfs_sfs.getVersion('UWSTORE');
 
GET_EPOCH
Returns the Unix epoch dbms_dbfs_sfs.get_epoch RETURN TIMESTAMP DETERMINISTIC;
SELECT dbms_dbfs_sfs.get_epoch;
 
INITFS
The table associated with the POSIX store "store_name" is truncated and reinitialized with a single "root" directory entry dbms_dbfs_sfs.initFS(store_name IN VARCHAR2);
exec dbms_dbfs_sfs.initFS('UWSTORE');
 
INITFSAUX
The table associated with the POSIX store "store_name" is truncated and reinitialized with a single "root" directory entry dbms_dbfs_sfs.initFSAux(
store_name IN VARCHAR2,
ctime      IN TIMESTAMP);
exec dbms_dbfs_sfs.initFSAux('UWSTORE', SYSTIMESTAMP);
 
ISPATHLOCKED
Returns 0 if the path is not locked otherwise the lock type dbms_dbfs_sfs.isPathLocked(
store_name IN     VARCHAR2,
path       IN     VARCHAR2,
who        IN     VARCHAR2,
lock_type  IN OUT INTEGER,
ctx        IN     dbms_dbfs_content_context_t);
TBD
 
LIST
List the contents of directory pathnames, optionally recursing into sub-directories, optionally seeing soft-deleted items, optionally using flashback "as of" a provided timestamp, and optionally filtering items IN/OUT within the store based on list/search predicates. dbms_dbfs_sfs.list(
store_name IN VARCHAR2,
path       IN VARCHAR2,
filter     IN VARCHAR2,
recurse    IN INTEGER,
ctx        IN dbms_dbfs_content_context_t)
RETURN dbms_dbfs_content_list_items_t PIPELINED;
TBD
 
LISTCURSOR
A highly specialized directory enumerator that is meant for use with dbms_fuse and dbfs_client as the ultimate callers, and with dbms_dbfs_sfs.listCursor as the callee dbms_dbfs_sfs.listCursor(
store_name IN VARCHAR2,
mnt_prefix IN VARCHAR2,
path       IN VARCHAR2,
withProps  IN INTEGER,
doSort     IN INTEGER,
doFts      IN INTEGER,
doBulk     IN INTEGER,
ctx        IN dbms_dbfs_content_context_t)
RETURN INTEGER;
TBD
 
LISTFILESYSTEMS
List all registered POSIX filesystems dbms_dbfs_sfs.listFileSystems RETURN filesystem_t PIPELINED;
SELECT * FROM TABLE(dbms_dbfs_sfs.listFileSystems);
 
LISTSNAPSHOTS
List all snapshots available for POSIX store tables dbms_dbfs_sfs.listSnapshots RETURN snapshots_t PIPELINED;
SELECT * FROM TABLE(dbms_dbfs_sfs.listSnapshots);
 
LISTTABLES
List all available store tables and their properties dbms_dbfs_sfs.listTables RETURN tables_t PIPELINED;
SELECT * FROM TABLE(dbms_dbfs_sfs.listTables);
 
LISTVOLUMES
List all volumes available for POSIX store tables dbms_dbfs_sfs.listVolumes RETURN volumes_t PIPELINED;
SELECT * FROM TABLE(dbms_dbfs_sfs.listVolumes);
 
LOCKPATH
Clients of the DBFS API can apply user-level locks to any valid pathname (subject to store feature support), associate the lock with user-data, and subsequently unlock these pathnames

Overload 1		 dbms_dbfs_sfs.lockPath(
store_name IN VARCHAR2,
path       IN VARCHAR2,
lock_type  IN INTEGER,
lock_data  IN VARCHAR2,
ctx        IN dbms_dbfs_content_context_t);
TBD
Overload 2 dbms_dbfs_sfs.lockPath(
store_name IN VARCHAR2,
path       IN VARCHAR2,
ctx        IN dbms_dbfs_content_context_t);
TBD
 
LOCKPATHAUX
Undocumented

Overload 1		 dbms_dbfs_sfs.lockPathAux(
store_name IN VARCHAR2,
path       IN VARCHAR2,
lock_type  IN INTEGER,
lock_data  IN VARCHAR2,
ctx        IN sys.dbms_dbfs_content_context_t,
ctime      IN TIMESTAMP);
TBD
Overload 2 dbms_dbfs_sfs.lockPathAux(
store_name     IN VARCHAR2,
path           IN VARCHAR2,
who            IN VARCHAR2,
lock_type      IN INTEGER,
waitforrowlock IN NUMBER,
ctx            IN sys.dbms_dbfs_content_context_t,
ctime          IN TIMESTAMP);
TBD
 
MOVEPATH
Pathnames can be renamed or moved across directory hierarchies and mount-points, but within the same store dbms_dbfs_sfs.movePath(
store_name IN            VARCHAR2,
oldPath    IN            VARCHAR2,
newPath    IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
ctx        IN            sys.dbms_dbfs_content_context_t);
TBD
 
NORMALIZEFS
Normalize the guid numbering of an existing POSIX store dbms_dbfs_sfs.normalizeFS(store_name IN VARCHAR2);
TBD
 
PURGEALL
Undocumented dbms_dbfs_sfs.purgeAll(
store_name IN VARCHAR2,
path       IN VARCHAR2,
filter     IN VARCHAR2,
ctx        IN dbms_dbfs_content_context_t);
TBD
 
PURGEALLLOCKS
Removes all locks on the identified store dbms_dbfs_sfs.purgeAllLocks(store_name IN VARCHAR2);
exec dbms_dbfs_sfs.purgeAllLocks('UWStore');
 
PURGELOCKSBYLOCKER
Removes locks on the identified store based on the source of the lock dbms_dbfs_sfs.purgeLocksByLocker(
store_name IN VARCHAR2,
who        IN VARCHAR2);
TBD
 
PURGELOCKSBYLOCKERAUX
Undocumented dbms_dbfs_sfs.purgeLocksByLockerAux(
store_name IN VARCHAR2,
who        IN VARCHAR2,
ctime      IN TIMESTAMP);
TBD
 
PURGELOCKSBYPATH
Removes locks on a store based on the path dbms_dbfs_sfs.purgeLocksByPath(
store_name IN VARCHAR2,
path       IN VARCHAR2);
TBD
 
PURGEPATH
Undocumented dbms_dbfs_sfs.purgePath(
store_name IN VARCHAR2,
path       IN VARCHAR2,
filter     IN VARCHAR2,
ctx        IN sys.dbms_dbfs_content_context_t);
TBD
 
PUTPATH
Undocumented

Overload 1		 dbms_dbfs_sfs.putPath(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
content    IN OUT NOCOPY BLOB,
item_type     OUT        INTEGER,
prop_flags IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t);
TBD
Overload 2 dbms_dbfs_sfs.putPath(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
amount     IN            NUMBER,
offset     IN            NUMBER,
buffer     IN            RAW,
prop_flags IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t);
TBD
Overload 3 dbms_dbfs_sfs.putPath(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
written       OUT        NUMBER,
offset     IN            NUMBER,
buffers    IN            sys.dbms_dbfs_content_raw_t,
prop_flags IN            INTEGER,
ctx        IN            sys.dbms_dbfs_content_context_t);
TBD
 
RECREATEGETATTRVIEW
Fastpath lookup view support. Meant for internal-use only during export/import operations. dbms_dbfs_sfs.recreateGetAttrView(
store_name IN VARCHAR2,
ctx        IN sys.dbms_dbfs_content_context_t,
view_name  IN VARCHAR2);
TBD
 
RECREATEOLDGETATTRVIEW
Undocumented dbms_dbfs_sfs.recreateOldGetAttrView(
store_name  IN VARCHAR2,
ctx         IN sys.dbms_dbfs_content_context_t,
view_name   IN VARCHAR2,
store_owner IN VARCHAR2 DEFAULT NULL);
TBD
 
REGISTERFILESYSTEM
Undocumented dbms_dbfs_sfs.registerFileSystem(
store_name  IN VARCHAR2,
schema_name IN VARCHAR2,
tbl_name    IN VARCHAR2,
vol_name    IN VARCHAR2 DEFAULT 'main',
snap_name   IN VARCHAR2 DEFAULT NULL);
TBD
 
REGISTERFILESYSTEMAUX
Undocumented dbms_dbfs_sfs.registerFileSystemAux(
store_name  IN VARCHAR2,
schema_name IN VARCHAR2,
tbl_name    IN VARCHAR2,
vol_name    IN VARCHAR2 DEFAULT 'main',
snap_name   IN VARCHAR2 DEFAULT null,
ctime       IN TIMESTAMP);
TBD
 
RENAMEPATH
Rename an existing path dbms_dbfs_sfs.renamePath(
store_name IN            VARCHAR2,
oldPath    IN            VARCHAR2,
newPath    IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
ctx        IN            sys.dbms_dbfs_content_context_t);
TBD
 
RENAMEPATHAUX
Undocumented dbms_dbfs_sfs.renamePathAux(
store_name IN            VARCHAR2,
oldPath    IN            VARCHAR2,
newPath    IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
ctx        IN            sys.dbms_dbfs_content_context_t,
isRename   IN            BOOLEAN,
ctime      IN            TIMESTAMP);
TBD
 
REORGANIZEFS
Online redefine/reorganize a POSIX store dbms_dbfs_sfs.reorganizeFS(srcStore IN VARCHAR2, dstStore IN VARCHAR2);
TBD
 
RESTOREALL
Undocumented dbms_dbfs_sfs.restoreAll(
store_name IN VARCHAR2,
path       IN VARCHAR2,
filter     IN VARCHAR2,
ctx        IN sys.dbms_dbfs_content_context_t);
TBD
 
RESTOREPATH
Undocumented dbms_dbfs_sfs.restorePath(
store_name IN VARCHAR2,
path       IN VARCHAR2,
filter     IN VARCHAR2,
ctx        IN sys.dbms_dbfs_content_context_t);
TBD
 
REVERTSNAPSHOT
Drops all snapshots/changes in the specified store/volume more recent than the specified snapshot dbms_dbfs_sfs.revertSnapshot(
store_name IN VARCHAR2,
snap_name  IN VARCHAR2,
vol_name   IN VARCHAR2 DEFAULT 'main',
do_wait    IN BOOLEAN  DEFAULT TRUE);
TBD
 
SEARCH
Search the contents of directory pathnames, optionally recursing into sub-directories, optionally seeing soft-deleted items, optionally using flashback "as of" a provided timestamp, and optionally filtering items IN/OUT within the store based on list/search predicates. dbms_dbfs_sfs.search(
store_name IN VARCHAR2,
path       IN VARCHAR2,
filter     IN VARCHAR2,
recurse    IN INTEGER,
ctx        IN sys.dbms_dbfs_content_context_t)
RETURN dbms_dbfs_content_list_items_t PIPELINED;
TBD
 
SETFSPROPERTIES
Sets properties for a Posix store dbms_dbfs_sfs.deleteFSProperties(
store_name IN VARCHAR2,
properties IN sys.dbms_dbfs_content_properties_t);
TBD
 
SETPATH
Undocumented dbms_dbfs_sfs.setPath(
store_name IN            VARCHAR2,
contentID  IN            RAW,
path       IN            VARCHAR2,
properties IN OUT NOCOPY sys.dbms_dbfs_content_properties_t,
ctx        IN            sys.dbms_dbfs_content_context_t);
TBD
 
SHRINKFS
Shrink Store POSIX File System dbms_dbfs_sfs.shrinkFS(
store_name IN VARCHAR2,
min_pct    IN NUMBER   DEFAULT NULL,
min_bytes  IN NUMBER   DEFAULT NULL,
dryrun     IN BOOLEAN  DEFAULT FALSE,
tbs        IN VARCHAR2 DEFAULT NULL);
TBD
 
SPACEUSAGE
Query file system space usage statistics

Overload 1		 dbms_dbfs_sfs.spaceUsage(
store_name IN  VARCHAR2,
blksize    OUT INTEGER,  -- natural tablespace block size holding the repository
tbytes     OUT INTEGER,  -- total repository size in bytes
fbytes     OUT INTEGER,  -- free unused repository in bytes
nfile      OUT INTEGER,  -- number of currently available files
ndir       OUT INTEGER,  -- number of currently available directories
nlink      OUT INTEGER,  -- number of currently available links
nref       OUT INTEGER); -- number of references in the repository
set serveroutput on

DECLARE
 vBlkSize INTEGER;
 vTBytes  INTEGER;
 vFBytes  INTEGER;
 vNFile   INTEGER;
 vNDir    INTEGER;
 vNLink   INTEGER;
 vNRef    INTEGER;
BEGIN
  dbms_dbfs_sfs.spaceUsage('UWStore', vBlkSize, vTBytes, vFBytes, vNFile, vNDir, vNLink, vNRef);

  dbms_output.put_line(vBlkSize);
  dbms_output.put_line(vTBytes);
  dbms_output.put_line(vFBytes);
  dbms_output.put_line(vNFile);
  dbms_output.put_line(vNDir);
  dbms_output.put_line(vNLink);
  dbms_output.put_line(vNRef);
END;
/
Overload 2 dbms_dbfs_sfs.spaceUsage(
store_name  IN  VARCHAR2,
blksize     OUT INTEGER,
tbytes      OUT INTEGER,
fbytes      OUT INTEGER,
nfile       OUT INTEGER,
ndir        OUT INTEGER,
nlink       OUT INTEGER,
nref        OUT INTEGER,
useEstimate IN  INTEGER);
TBD
 
SPACEUSAGEFULL
Undocumented

Overload 1		 dbms_dbfs_sfs.spaceUsageFull(
store_names IN  sys.dbms_dbfs_content_properties_t,
blksize     OUT INTEGER,
tbytes      OUT INTEGER,
fbytes      OUT INTEGER,
nfile       OUT INTEGER,
ndir        OUT INTEGER,
nlink       OUT INTEGER,
nref        OUT INTEGER);
TBD
Overload 2 dbms_dbfs_sfs.spaceUsageFull(
store_names IN  sys.dbms_dbfs_content_properties_t,
blksize     OUT INTEGER,
tbytes      OUT INTEGER,
fbytes      OUT INTEGER,
nfile       OUT INTEGER,
ndir        OUT INTEGER,
nlink       OUT INTEGER,
nref        OUT INTEGER,
useEstimate IN  INTEGER);
TBD
 
TO_EPOCH
Timestamp to UNIX epoch converter dbms_dbfs_sfs.to_epoch(tv IN TIMESTAMP) RETURN INTEGER DETERMINISTIC;
SELECT dbfs_sfs.to_epoch(SYSTIMESTAMP);
 
UNLOCKPATH
Unlock any valid pathname associated with user-data

Overload 1		 dbms_dbfs_sfs.unlockPath(
store_name IN VARCHAR2,
path       IN VARCHAR2,
ctx        IN sys.dbms_dbfs_content_context_t);
TBD
Overload 2 dbms_dbfs_sfs.unlockPath(
store_name     IN VARCHAR2,
path           IN VARCHAR2,
who            IN VARCHAR2,
waitforrowlock IN NUMBER,
ctx            IN sys.dbms_dbfs_content_context_t);
TBD
 
UNLOCKPATHAUX
Undocumented

Overload 1		 dbms_dbfs_sfs.unlockPathAux(
store_name IN VARCHAR2,
path       IN VARCHAR2,
ctx        IN sys.dbms_dbfs_content_context_t,
ctime      IN TIMESTAMP);
TBD
Overload 2 dbms_dbfs_sfs.unlockPathAux(
store_name     IN VARCHAR2,
path           IN VARCHAR2,
who            IN VARCHAR2,
waitforrowlock IN NUMBER,
ctx            IN sys.dbms_dbfs_content_context_t,
ctime          IN TIMESTAMP);
TBD
UNREGISTERFILESYSTEM
It is necessary to run dropFilesystem or unregisterFilesystem before a store table can be dropped dbms_dbfs_sfs.unregisterFileSystem(store_name IN VARCHAR2);
exec dbms_dbfs_sfs.unregisterFileSystem('UWSTORE');

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_ADMIN
DBMS_SPACE
What's New In 21c
What's New In 26ai

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