Oracle DBMS_DBFS_SFS
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
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');
 
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
 
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

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