Oracle DBMS_DBFS_SFS
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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  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 dbms_dbfs_content_properties_t);
TBD
 
APPEND (new 21c)
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 dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
recurse    IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t);
TBD
 
CREATEDIRECTORYAUX (new 21c)
Undocumented dbms_dbfs_sfs.createDirectoryAux(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
recurse    IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t,
ctime      IN            TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(createDirectoryAux, AUTO);
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 dbms_dbfs_content_properties_t,
content    IN OUT NOCOPY BLOB,
prop_flags IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t);
TBD
 
CREATEFILEAUX (new 21c)
Undocumented dbms_dbfs_sfs.createFileAux(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
content    IN OUT NOCOPY BLOB,
prop_flags IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t,
ctime      IN            TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(createFileAux, AUTO);
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 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 (new 21c)
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 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);
PRAGMA supplemental_log_data(createFilesystemAux, AUTO_WITH_COMMIT);
TBD
 
CREATEGETATTRVIEW
Create a Fastpath lookup view dbms_dbfs_sfs.createGetAttrView(
store_name IN  VARCHAR2,
cts        IN  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 dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t);
TBD
 
CREATELINKAUX (new 21c)
Undocumented dbms_dbfs_sfs.createLinkAux(
store_name IN            VARCHAR2,
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t,
ctime      IN            TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(createLinkAux, AUTO);
TBD
 
CREATEREFERENCE
Undocumented dbms_dbfs_sfs.createReference(
store_name IN            VARCHAR2,
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t);
TBD
 
CREATEREFERENCEAUX (new 21c)
Undocumented dbms_dbfs_sfs.createReferenceAux(
store_name IN            VARCHAR2,
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER,
ctx        IN            dbms_dbfs_content_context_t,
ctime      IN            TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(createReferenceAux, AUTO);
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 dbms_dbfs_content_context_t);
TBD
 
DELETECONTENTAUX (new 21c)
Undocumented dbms_dbfs_sfs.deleteContentAux(
store_name  IN VARCHAR2,
contentID   IN RAW,
filter      IN VARCHAR2,
soft_delete IN INTEGER,
ctx         IN dbms_dbfs_content_context_t,
ctime       IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(deleteContentAux, AUTO);
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 dbms_dbfs_content_context_t);
TBD
 
DELETEDIRECTORYAUX (new 21c)
Undocumented dbms_dbfs_sfs.deleteDirectoryAux(
store_name  IN VARCHAR2,
path        IN VARCHAR2,
filter      IN VARCHAR2,
soft_delete IN INTEGER,
recurse     IN INTEGER,
ctx         IN dbms_dbfs_content_context_t,
ctime       IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(deleteDirectoryAux, AUTO);
TBD
 
DELETEFSPROPERTIES
Deletes properties from a POSIX store dbms_dbfs_sfs.deleteFSProperties(
store_name IN VARCHAR2,
properties IN 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 dbms_dbfs_content_context_t);
TBD
 
DELETEFILEAUX (new 21c)
Undocumented dbms_dbfs_sfs.deleteFileAux(
store_name  IN VARCHAR2,
path        IN VARCHAR2,
filter      IN VARCHAR2,
soft_delete IN INTEGER,
ctx         IN dbms_dbfs_content_context_t,
ctime       IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(deleteFileAux, AUTO);
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 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 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  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 (new 21c)
Undocumented dbms_dbfs_sfs.fs_chmodAux(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN dbms_dbfs_content_context_t,
path    IN VARCHAR2,
st_mode IN INTEGER,
ctime   IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(fs_chmodAux, AUTO);
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 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  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 (new 21c)
Undocumented dbms_dbfs_sfs.fs_chownAux(
store  IN VARCHAR2,
mount  IN VARCHAR2,
ctx    IN dbms_dbfs_content_context_t,
path   IN VARCHAR2,
st_uid IN INTEGER,
st_gid IN INTEGER,
ctime  IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(fs_chownAux, AUTO);
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         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         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  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 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 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 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            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  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         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
FROM dual;
 
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 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  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 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 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  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 (new 21c)
Undocumented dbms_dbfs_sfs.fs_mkDiri(
store       IN  VARCHAR2,
mount       IN  VARCHAR2,
ctx         IN  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);
PRAGMA SUPPLEMENTAL_LOG_DATA(fs_mkdirI, AUTO);
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 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 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 (new 21c)
Undocumented dbms_dbfs_sfs.fs_mkNodOp(
store       IN         VARCHAR2,
mount       IN         VARCHAR2,
ctx         IN         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);
PRAGMA SUPPLEMENTAL_LOG_DATA(fs_mknodOp, AUTO);
TBD
 
FS_MKSOC (new 21c)
Undocumented

Overload 1		 dbms_dbfs_sfs.fs_mkSoc(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN 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  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         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         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 (new 21c)
Undocumented dbms_dbfs_sfs.fs_openAux(
store    IN  VARCHAR2,
mount    IN  VARCHAR2,
ctx      IN  dbms_dbfs_content_context_t,
path     IN  VARCHAR2,
content  OUT NOCOPY BLOB,
forWrite IN         INTEGER,
ctime    IN         TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(fs_openAux, AUTO);
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 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         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         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 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         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 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 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 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 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 dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_RMDIRI (new 21c)
Undocumented dbms_dbfs_sfs.fs_rmDiri(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN dbms_dbfs_content_context_t,
path  IN VARCHAR2,
ctime IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(fs_rmdirI, AUTO);
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 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  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 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  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 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  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 dbms_dbfs_content_context_t,
path  IN VARCHAR2)
RETURN INTEGER;
TBD
 
FS_UNLINKOP (new 21c)
Undocumented dbms_dbfs_sfs.fs_unlinkOp(
store IN VARCHAR2,
mount IN VARCHAR2,
ctx   IN dbms_dbfs_content_context_t,
path  IN VARCHAR2,
ctime IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(fs_unlinkOp, AUTO);
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 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  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 (new 21c)
Undocumented dbms_dbfs_sfs.fs_utimeAux(
store   IN VARCHAR2,
mount   IN VARCHAR2,
ctx     IN dbms_dbfs_content_context_t,
path    IN VARCHAR2,
atime   IN INTEGER,
mtime   IN INTEGER,
atimens IN INTEGER,
mtimens IN INTEGER,
ctime   IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(fs_utimeAux, AUTO);
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 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  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 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  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')
FROM dual;
 
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')
FROM dual;
 
GETVERSION
Returns a store's version dbms_dbfs_sfs.getVersion(store_name IN VARCHAR2)
RETURN VARCHAR2;
SELECT dbms_dbfs_sfs.getVersion('UWSTORE')
FROM dual;
 
GET_EPOCH
Returns the Unix epoch dbms_dbfs_sfs.get_epoch RETURN TIMESTAMP DETERMINISTIC;
SELECT dbms_dbfs_sfs.get_epoch
FROM dual;
 
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 (new 21c)
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);
PRAGMA SUPPLEMENTAL_LOG_DATA(initFSAux, AUTO);
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 (new 21c)
Undocumented dbms_dbfs_sfs.lockPathAux(
store_name IN VARCHAR2,
path       IN VARCHAR2,
lock_type  IN INTEGER,
lock_data  IN VARCHAR2,
ctx        IN dbms_dbfs_content_context_t,
ctime      IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(lockPathAux, AUTO);
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 dbms_dbfs_content_properties_t,
ctx        IN            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 (new 21c)
Undocumented dbms_dbfs_sfs.purgeLocksByLockerAux(
store_name IN VARCHAR2,
who        IN VARCHAR2,
ctime      IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(purgeLocksByLockerAux, AUTO);
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 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            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            dbms_dbfs_content_context_t);
TBD
Overload 3 dbms_dbfs_sfs.putPath(
store_name IN            VARCHAR2,
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
written       OUT        NUMBER,
offset     IN            NUMBER,
buffers    IN            dbms_dbfs_content_raw_t,
prop_flags IN            INTEGER,
ctx        IN            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 dbms_dbfs_content_context_t,
view_name  IN VARCHAR2);
TBD
 
RECREATEOLDGETATTRVIEW (new 21c)
Undocumented dbms_dbfs_sfs.recreateOldGetAttrView(
store_name  IN VARCHAR2,
ctx         IN dbms_dbfs_content_context_t,
view_name   IN VARCHAR2,
store_owner IN VARCHAR2 default NULL);
PRAGMA SUPPLEMENTAL_LOG_DATA(recreateOldGetattrView, AUTO_WITH_COMMIT);
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 (new 21c)
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);
PRAGMA SUPPLEMENTAL_LOG_DATA(registerFilesystemAux, AUTO_WITH_COMMIT);
TBD
 
RENAMEPATH
Rename an existing path dbms_dbfs_sfs.renamePath(
store_name IN            VARCHAR2,
oldPath    IN            VARCHAR2,
newPath    IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
ctx        IN            dbms_dbfs_content_context_t);
TBD
 
RENAMEPATHAUX (new 21c)
Undocumented dbms_dbfs_sfs.renamePathAux(
store_name IN            VARCHAR2,
oldPath    IN            VARCHAR2,
newPath    IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
ctx        IN            dbms_dbfs_content_context_t,
isRename   IN            BOOLEAN,
ctime      IN            TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(renamePathAux, AUTO);
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 dbms_dbfs_content_context_t);
TBD
 
RESTOREPATH
Undocumented dbms_dbfs_sfs.restorePath(
store_name IN VARCHAR2,
path       IN VARCHAR2,
filter     IN VARCHAR2,
ctx        IN 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 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 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 dbms_dbfs_content_properties_t,
ctx        IN            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  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  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)
FROM dual;
 
UNLOCKPATH
Unlock any valid pathname associated with user-data dbms_dbfs_sfs.unlockPath(
store_name IN VARCHAR2,
path       IN VARCHAR2,
ctx        IN dbms_dbfs_content_context_t);
TBD
 
UNLOCKPATHAUX (new 21c)
Undocumented dbms_dbfs_sfs.unlockPathAux(
store_name IN VARCHAR2,
path       IN VARCHAR2,
ctx        IN dbms_dbfs_content_context_t,
ctime      IN TIMESTAMP);
PRAGMA SUPPLEMENTAL_LOG_DATA(unlockPathAux, AUTO);
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 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx