Oracle DBMS_DBFS_SFS
Version 11.2.0.3
 
General Information
Purpose Specification for the "dbms_dbfs_sfs" and "dbms_dbfs_sfs_admin" packages. The SFS provider implements POSIX filesystem
Source {ORACLE_HOME}/rdbms/admin/dbmsfspi.sql
First Available 11.2
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'
Dependencies
ALL_PROCEDURES DBMS_DBFS_CONTENT_LIST_ITEM_T
DBFS_SFS$_FS DBMS_DBFS_CONTENT_PROPERTIES_T
DBFS_SFS$_FSSEQ DBMS_DBFS_CONTENT_PROPERTY_T
DBFS_SFS$_FST DBMS_DBFS_CONTENT_RAW_T
DBFS_SFS$_FSTO DBMS_DBFS_HS
DBFS_SFS$_FSTP DBMS_DBFS_SFS_ADMIN
DBFS_SFS$_SNAP DBMS_DB_VERSION
DBFS_SFS$_TAB DBMS_LOB
DBFS_SFS$_VOL DUAL
DBMS_ASSERT PLITBLM
DBMS_DBFS_CONTENT SYS_STUB_FOR_PURITY_ANALYSIS
DBMS_DBFS_CONTENT_CONTEXT_T UTL_RAW
DBMS_DBFS_CONTENT_LIST_ITEMS_T  
Defined 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;
Exceptions
Exception Number Exception Name
ORA-64007 Invalid Store Specified
Security Model Execute is granted to DBFS_ROLE. Runs with AUTHID CURRENT_USER.
Subprograms
ADDFSPROPERTIES FS_GETATTR GET_EPOCH
CHECKACCESS FS_GETXATTR INITFS
CLEANUPORPHANS FS_INIT LIST
CREATEDIRECTORY FS_LINK LISTCURSOR
CREATEFILE FS_LISTXATTR LISTFILESYSTEMS
CREATEFILESYSTEM FS_MKDIR LISTSNAPSHOTS
CREATEGETATTRVIEW FS_MKNOD LISTTABLES
CREATELINK FS_OPEN LISTVOLUMES
CREATEREFERENCE FS_OPENDIR LOCKPATH
CREATESNAPSHOT FS_READ MOVEPATH
CREATESTORE FS_READDIR NORMALIZEFS
DELETECONTENT FS_READLINK PURGEALL
DELETEDIRECTORY FS_RELEASE PURGEPATH
DELETEFILE FS_RELEASEDIR PUTPATH
DELETEFSPROPERTIES FS_REMOVEXATTR RECREATEGETATTRVIEW
DROPFILESYSTEM FS_RENAME REGISTERFILESYSTEM
DROPGETATTRVIEW FS_RMDIR RENAMEPATH
DROPSNAPSHOT FS_SETXATTR REORGANIZEFS
EXPORTFILESYSTEM FS_STATFS RESTOREALL
EXPORTTABLE FS_SYMLINK RESTOREPATH
FS_ACCESS FS_TRUNCATE REVERTSNAPSHOT
FS_CHMOD FS_UNLINK SEARCH
FS_CHOWN FS_UTIME SETFSPROPERTIES
FS_CREAT FS_WRITE SETPATH
FS_DESTROY GETFEATURES SHRINKFS
FS_FGETATTR GETPATH SPACEUSAGE
FS_FLUSH GETPATHBYSTOREID SPACEUSAGEFULL
FS_FSYNC GETPATHNOWAIT TO_EPOCH
FS_FSYNCDIR GETSTOREID UNLOCKPATH
FS_FTRUNCATE GETVERSION UNREGISTERFILESYSTEM
 
ADDFSPROPERTIES (new 11.2.0.2)
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 (new 11.2.0.3)
Drop orphaned POSIX stores. Runs like DDL with double commits. 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 (new in 11.2.0.2)
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
A 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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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(retVal);
END;
/
 
FS_FGETATTR (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new in 11.2.0.2)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new 11.2.0.2, new parameters in return array 11.2.0.3)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new in 11.2.0.2)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new 11.2.0.2, new parameters 11.2.0.3)
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 (new in 11.2.0.2)
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 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 (new 11.2.0.3)
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 (new 11.2.0.3)
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 (new 11.2.0.3)
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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
Undocumented 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 (new in 11.2.0.2)
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(???, 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;
/
Undocumented

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 (new in 11.2.0.2)
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 (new in 11.2.0.2)
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
 
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-2013 Daniel A. Morgan All Rights Reserved