Oracle DBMS_DBFS_SFS
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Specification for the "dbms_dbfs_sfs" and "dbms_dbfs_sfs_admin" packages. The SFS provider implements POSIX filesystem
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'
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;

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;

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 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;
Dependencies
ALL_CONSTRAINTS DBFS_SFS$_SNAP DBMS_FUSE
ALL_INDEXES DBFS_SFS$_TAB DBMS_LOB
ALL_NESTED_TABLES DBFS_SFS$_VOL DBMS_REDEFINITION
ALL_OBJECTS DBMS_ASSERT DBMS_SQL
ALL_PROCEDURES DBMS_DBFS_CONTENT DBMS_TYPES
ALL_TABLES DBMS_DBFS_CONTENT_CONTEXT_T DUAL
ALL_TAB_COLS DBMS_DBFS_CONTENT_LIST_ITEMS_T PLITBLM
ALL_TAB_PARTITIONS DBMS_DBFS_CONTENT_LIST_ITEM_T SYS_STUB_FOR_PURITY_ANALYSIS
ALL_VIEWS DBMS_DBFS_CONTENT_PROPERTIES_T USER_CONSTRAINTS
DBFS_SFS$_FS DBMS_DBFS_CONTENT_PROPERTY_T USER_INDEXES
DBFS_SFS$_FSSEQ DBMS_DBFS_CONTENT_RAW_T USER_IND_COLUMNS
DBFS_SFS$_FST DBMS_DBFS_HS USER_TABLES
DBFS_SFS$_FSTO DBMS_DBFS_SFS_ADMIN UTL_RAW
DBFS_SFS$_FSTP DBMS_DB_VERSION  
Documented Yes
Exceptions
Error Code Reason
ORA-64007 Invalid Store Specified
First Available 11.2.0.1
Security Model Owned by SYS with EXECUTE granted to the  DBFS_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmsfspi.sql
Subprograms
 
ADDFSPROPERTIES
Adds properties to a POSIX store dbms_dbfs_sfs.addFSProperties(
store_name IN VARCHAR2,
properties IN dbms_dbfs_content_properties_t);
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
 
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
 
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
 
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
 
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
 
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
 
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
 
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
 
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_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_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_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_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_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_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_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_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
Initializes a POSIX store file system dbms_dbfs_sfs.initFS(store_name IN VARCHAR2);
exec dbms_dbfs_sfs.initFS('UWSTORE');
 
ISPATHLOCKED (new 12.2)
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
 
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 (new 12.2)
Removes all locks on the identified store dbms_dbfs_sfs.purgeAllLocks(store_name IN VARCHAR2);
exec dbms_dbfs_sfs.purgeAllLocks('UWStore');
 
PURGELOCKSBYLOCKER (new 12.2)
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
 
PURGELOCKSBYPATH (new 12.2)
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
 
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
 
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
 
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
 
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
DBMS_APBACKEND
DBMS_DBFS_CONTENT
DBMS_DBFS_CONTENT_ADMIN
DBMS_DBFS_CONTENT_SPI
DBMS_DBFS_HS
DBMS_DBFS_SFS_ADMIN
DBMS_SPACE
Packages
What's New In 12cR1
What's New In 12cR2

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