Oracle DBMS_DBFS_CONTENT
Version 11.2.0.3
 
General Information
Source {ORACLE_HOME}/rdbms/admin/dbmscapi.sql
Note: See also {ORACLE_HOME}/rdbms/admin/dbfs_create_filesystem_advanced.sql
First Available 11.1
Constants
Name Data Type Value
Content ID Constants
prop_none (none) PLS_INTEGER 0
prop_std (mandatory) PLS_INTEGER 1
prop_opt (optional) PLS_INTEGER 2
CONTENT_ID_MAX PLS_INTEGER 128
NAME_MAX PLS_INTEGER 256
PATH_MAX PLS_INTEGER 1024
TYPE_DIRECTORY (directory) PLS_INTEGER 2
TYPE_FILE (normal file) PLS_INTEGER 1
TYPE_LINK (symbolic link) PLS_INTEGER 3
TYPE_REFERENCE (hard link) PLS_INTEGER 4
Feature Types
feature_folders PLS_INTEGER 1
feature_foiat PLS_INTEGER 2
feature_nowait PLS_INTEGER 4
feature_acls PLS_INTEGER 8
feature_links PLS_INTEGER 16
feature_link_deref PLS_INTEGER 32
feature_references PLS_INTEGER 64
feature_locking PLS_INTEGER 128
feature_hierarchy PLS_INTEGER 256
feature_convert PLS_INTEGER 512
feature_versioning PLS_INTEGER 1024
feature_version_path PLS_INTEGER 2048
feature_soft_deletes PLS_INTEGER 4096
feature_hashing PLS_INTEGER 8102
feature_hash_lookup PLS_INTEGER 16384
feature_filtering PLS_INTEGER 32768
feature_searching PLS_INTEGER 65536
feature_asof PLS_INTEGER 131072
feature_provider_props PLS_INTEGER 262144
feature_snapshots PLS_INTEGER 524288
feature_dot_snapshot PLS_INTEGER 1048576
feature_clones PLS_INTEGER 209712
feature_locator PLS_INTEGER 4194304
feature_content_id PLS_INTEGER 8388608
feature_lazy_path PLS_INTEGER 16777216
feature_no_special PLS_INTEGER 33554432
feature_getattr_view PLS_INTEGER 67108864
Lock Types
lock_read_only PLS_INTEGER 1
lock_write_only PLS_INTEGER 2
lock_read_write PLS_INTEGER 3
Optional Properties
opt_hash_type VARCHAR2(32) 'opt:hash_type'
opt_hash_value VARCHAR2(32) 'opt:hash_value'
opt_lock_count VARCHAR2(32) 'opt:lock_count'
opt_lock_data VARCHAR2(32) 'opt:lock_data'
opt_locker VARCHAR2(32) 'opt:locker'
opt_lock_status VARCHAR2(32) 'opt:lock_status'
opt_version VARCHAR2(32) 'opt:version'
opt_version_path VARCHAR2(32) 'opt:version_path'
opt_content_id VARCHAR2(32) 'opt:content_id'
Path Names
name_max PLS_INTEGER 256
path_max PLS_INTEGER 1024
Path Properties
PROPNAME_MAX PLS_INTEGER 32
PROPVAL_MAX PLS_INTEGER 1024
Property Access Flags
prop_none (none) PLS_INTEGER 0
prop_std (mandatory) PLS_INTEGER 1
prop_opt (optional) PLS_INTEGER 2
prop_usr (user defined) PLS_INTEGER 4
prop_all (all) PLS_INTEGER prop_std + prop_opt + prop_usr
prop_data (content) PLS_INTEGER 8
prop_spc (specific) PLS_INTEGER 16
Standard Properties
std_access_time VARCHAR2(32) 'std:access_time'
std_acl constant VARCHAR2(32) 'std:acl'
std_canonical_path VARCHAR2(32) 'std:canonical_path'
std_change_time VARCHAR2(32) 'std:change_time'
std_children VARCHAR2(32) 'std:children'
std_content_type VARCHAR2(32) 'std:content_type'
std_creation_time VARCHAR2(32) 'std:creation_time'
std_deleted VARCHAR2(32) 'std:deleted'
std_guid VARCHAR2(32) 'std:guid'
std_length VARCHAR2(32) 'std:length'
std_modification_time VARCHAR2(32) 'std:modification_time'
std_owner VARCHAR2(32) 'std:owner'
std_parent_guid VARCHAR2(32) 'std:parent_guid'
std_referent VARCHAR2(32) 'std:referent'
Data Types SUBSTYPE content_id_t IS RAW(128);

SUBTYPE name_t IS VARCHAR2(256);

SUBTYPE path_t IS VARCHAR2(1024);

SUBTYPE propname_t IS VARCHAR2(32);

SUBTYPE propval_t IS VARCHAR2(1024);
Dependencies
ALL_PROCEDURES DBMS_DBFS_CONTENT_RAW_T
ALL_SYNONYMS DBMS_DBFS_HS
DBFS$_MOUNTS DBMS_DBFS_SFS
DBFS$_STORES DBMS_DBFS_SFS_ADMIN
DBFS_CONTENT DBMS_DB_VERSION
DBFS_CONTENT_PROPERTIES DBMS_FUSE
DBMS_ARCH_PROVIDER_INTL DBMS_LOB
DBMS_ASSERT DBMS_LOB_AM_PRIVATE
DBMS_DBFS_CONTENT_ADMIN DBMS_SYSTEM
DBMS_DBFS_CONTENT_CONTEXT_T DBMS_UTILITY
DBMS_DBFS_CONTENT_LIST_ITEMS_T DUAL
DBMS_DBFS_CONTENT_LIST_ITEM_T PLITBLM
DBMS_DBFS_CONTENT_PROPERTIES_T SYS_PLSQL_8580_835_1
DBMS_DBFS_CONTENT_PROPERTY_T SYS_STUB_FOR_PURITY_ANALYSIS
Exceptions
Number Name
-64000 path_exists
-64001 invalid_parent
-64002 invalid_path
-64003 unsupported_operations
-64004 invalid_arguments
-64005 invalid_access
-64006 lock_conflict
-64007 invalid_store
-64008 invalid_mount
-64009 invalid_provider
-64010 readonly_path
Security Model Execute is granted to the DBFS_ROL role

Compiled with AUTHID CURRENT_USER
Subprograms
CHECKACCESS GETSTATS PROPVARCHAR2
CHECKSPI GETSTOREBYMOUNT PURGEALL
CREATEREFERENCE GETSTOREBYNAME PURGEPATH
DECODEFEATURES GETSTOREBYPATH PUTPATH
DELETECONTENT GETTRACE REGISTERSTORE
DELETEDIRECTORY GETVERSION RENAMEPATH
DELETEFILEv LIST RESTOREALL
FEATURENAME LISTALLCONTENT RESTOREPATH
FLUSHSTATS LISTALLPROPERTIES SEARCH
GETATTR_VIEW LISTCURSOR SETDEFAULTACL
GETDEFAULTACL LISTMOUNTS SETDEFAULTASOF
GETDEFAULTASOF LISTSTORES SETDEFAULTCONTEXT
GETDEFAULTCONTEXT LOCKPATH SETDEFAULTOWNER
GETDEFAULTOWNER MOUNTSTORE SETDEFAULTPRINCIPAL
GETDEFAULTPRINCIPAL MOVEPATH SETPATH
GETFEATURESBYMOUNT NORMALIZEPATH SETSTATS
GETFEATURESBYNAME PROPANY SETTRACE
GETFEATURESBYPATH PROPERTIESH2T SPACEUSAGE
GETPATH PROPERTIEST2H TRACE
GETPATHBYMOUNTID PROPNUMBER TRACEENABLED
GETPATHBYSTOREID PROPRAW UNLOCKPATH
GETPATHNOWAIT PROPTIMESTAMP UNMOUNTALL
CREATEDIRECTORY REMOUNTALL UNMOUNTSTORE
CREATEFILE REMOUNTSTORE UNREGISTERSTORE
CREATELINK    
 
CHECKACCESS
Check if a given pathname (path, pathtype, store_name) can be manipulated by "operation (see the various "op_xxx" opcode above) by "principal" dbms_dbfs_content.checkAccess(
path       IN VARCHAR2,
pathtype   IN INTEGER,
operation  IN VARCHAR2,
principal  IN VARCHAR2,
store_name IN VARCHAR2 DEFAULT NULL)
RETURN BOOLEAN;
TBD
 
CHECKSPI
Given the name of a putative dbms_dbfs_content_spi conforming package, attempt to check that the package really does implement all of the provider methods (with the proper signatures), and report on the conformance
Overload 1		 dbms_dbfs_content.checkSpi(package_name IN VARCHAR2) RETURN CLOB;
TBD
Overload 2 dbms_dbfs_content.checkSpi(schema_name IN VARCHAR2, package_name IN VARCHAR2)
RETURN CLOB;
TBD
Overload 3 dbms_dbfs_content.checkSpi(package_name IN VARCHAR2, chk IN OUT NOCOPY CLOB);
TBD
Overload 4 dbms_dbfs_content.checkSpi(
schema_name  IN            VARCHAR2,
package_name IN            VARCHAR2,
chk          IN OUT NOCOPY CLOB);
TBD
 
CREATEDIRECTORY
Undocumented

Overload 1		 dbms_dbfs_content.createDirectory( path IN VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER  DEFAULT prop_std,
recurse    IN            BOOLEAN  DEFAULT FALSE,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_dbfs_content.createDirectory(
path       IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
prop_flags IN            INTEGER DEFAULT prop_std,
recurse    IN            BOOLEAN DEFAULT FALSE,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
 
CREATEFILE
Create a file element

Overload 1		 dbms_dbfs_content.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
Overload 2 dbms_dbfs_content.createFile(
path       IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
content    IN OUT NOCOPY BLOB,
prop_flags IN            INTEGER DEFAULT (prop_std + prop_data),
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
 
CREATELINK
Create a link element

Overload 1		 dbms_dbfs_content.createLink(
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER DEFAULT prop_std,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_dbfs_content.createLink(
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
prop_flags IN            INTEGER DEFAULT prop_std,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
 
CREATEREFERENCE
Create a reference element

Overload 1		 dbms_dbfs_content.createReference(
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
prop_flags IN            INTEGER DEFAULT prop_std,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_dbfs_content.createreference(
srcPath    IN            VARCHAR2,
dstPath    IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
prop_flags IN            INTEGER DEFAULT prop_std,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
 
DECODEFEATURES
Undocumented dbms_dbfs_content.decodeFeatures(featureSet IN INTEGER)
RETURN features_t deterministic PIPELINED;
TBD
 
DELETECONTENT
Undocumented dbms_dbfs_content.decodeContent(
store_name  IN VARCHAR2,
contentID   IN RAW,
filter      IN VARCHAR2 DEFAULT NULL,
soft_delete IN BOOLEAN  DEFAULT NULL,
principal   IN VARCHAR2 DEFAULT NULL);
TBD
 
DELETEDIRECTORY
Undocumented dbms_dbfs_content.deleteDirectory(
path        IN VARCHAR2,
filter      IN VARCHAR2 DEFAULT NULL,
soft_delete IN BOOLEAN  DEFAULT NULL,
recurse     IN BOOLEAN  DEFAULT FALSE,
store_name  IN VARCHAR2 DEFAULT NULL,
principal   IN VARCHAR2 DEFAULT NULL);
TBD
 
DELETEFILE
Undocumented dbms_dbfs_content.deleteFile(
path        IN VARCHAR2,
filter      IN VARCHAR2 DEFAULT NULL,
soft_delete IN BOOLEAN  DEFAULT NULL,
store_name  IN VARCHAR2 DEFAULT NULL,
principal   IN VARCHAR2 DEFAULT NULL);
TBD
 
FEATURENAME
Undocumented dbms_dbfs_content.featureName(featureBit IN INTEGER)
RETURN VARCHAR2 DETERMINISTIC;
TBD
 
FLUSHSTATS
Flush collected statistics dbms_dbfs_content.FlushStats;
exec dbms_dbfs_content.FlushStats;
 
GETATTR_VIEW (new 11.2.0.2)
Returns the name of the Fastpath lookup acceleration view dbms_dbfs_content.getAttr_View(
path      IN         VARCHAR2,
prefix    OUT NOCOPY VARCHAR2,
view_name OUT NOCOPY VARCHAR2);
TBD
 
GETDEFAULTACL
Undocumented dbms_dbfs_content.getDefaultACL RETURN VARCHAR2;
SELECT dbms_dbfs_content.getDEFAULTacl FROM dual;
 
GETDEFAULTASOF
Undocumented dbms_dbfs_content.getDefaultAsOf RETURN TIMESTAMP;
SELECT dbms_dbfs_content.getDEFAULTasof FROM dual;
 
GETDEFAULTCONTEXT
Undocumented dbms_dbfs_content.getDefaultContext(
principal OUT NOCOPY VARCHAR2,
owner     OUT NOCOPY VARCHAR2,
acl       OUT NOCOPY VARCHAR2,
asof      OUT        TIMESTAMP);
TBD
 
GETDEFAULTOWNER
Returns the store's DEFAULT owner dbms_dbfs_content.getDefaultOwner RETURN VARCHAR2;
SELECT dbms_dbfs_content.getDefaultOwner FROM dual;
 
GETDEFAULTPRINCIPAL
Undocumented dbms_dbfs_content.getDefaultPrincipal RETURN VARCHAR2;
SELECT dbms_dbfs_content.getDefaultPrincipal FROM dual;
 
GETFEATURESBYMOUNT
Look up store feature by mount dbms_dbfs_content.getFeaturesByMount(store_mount IN VARCHAR2) RETURN INTEGER;
TBD
 
GETFEATURESBYNAME
Look up store feature by name dbms_dbfs_content.getFeaturesByName(store_name IN VARCHAR2) RETURN INTEGER;
TBD
 
GETFEATURESBYPATH
Look up store feature by path dbms_dbfs_content.getFeaturesByPath(path IN path_t) RETURN INTEGER;
TBD
 
GETPATH
Undocumented

Overload 1		 dbms_dbfs_content.getPath(
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
content       OUT NOCOPY BLOB,
item_type     OUT        INTEGER,
prop_flags IN            INTEGER   DEFAULT (prop_std + prop_opt + prop_data),
asof       IN            TIMESTAMP DEFAULT NULL,
forUpdate  IN            BOOLEAN   DEFAULT FALSE,
deref      IN            BOOLEAN   DEFAULT FALSE,
store_name IN            VARCHAR2  DEFAULT NULL,
principal  IN            VARCHAR2  DEFAULT NULL);
TBD
Overload 2 dbms_dbfs_content.getPath(
path       IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
content       OUT NOCOPY BLOB,
item_type     OUT        INTEGER,
prop_flags IN            INTEGER   DEFAULT (prop_std + prop_opt + prop_data),
asof       IN            TIMESTAMP DEFAULT NULL,
forUpdate  IN            BOOLEAN   DEFAULT FALSE,
deref      IN            BOOLEAN   DEFAULT FALSE,
store_name IN            VARCHAR2  DEFAULT NULL,
principal  IN            VARCHAR2  DEFAULT NULL);
TBD
Overload 3 dbms_dbfs_content.getPath(
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   DEFAULT (prop_std + prop_opt),
asof       IN            TIMESTAMP DEFAULT NULL,
store_name IN            VARCHAR2  DEFAULT NULL,
principal  IN            VARCHAR2  DEFAULT NULL);
TBD
Overload 4 dbms_dbfs_content.getPath(
path       IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
amount     IN OUT        NUMBER,
offset     IN            NUMBER,
buffer        OUT NOCOPY RAW,
prop_flags IN            INTEGER   DEFAULT (prop_std + prop_opt),
asof       IN            TIMESTAMP DEFAULT NULL,
store_name IN            VARCHAR2  DEFAULT NULL,
principal  IN            VARCHAR2  DEFAULT NULL);
TBD
Overload 5 dbms_dbfs_content.getPath(
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 DEFAULT (prop_std + prop_opt),
asof       IN            TIMESTAMP DEFAULT NULL,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 6 dbms_dbfs_content.getPath(
path       IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
amount     IN OUT        NUMBER,
offset     IN            NUMBER,
buffers       OUT NOCOPY dbms_dbfs_content_RAW_t,
prop_flags IN            INTEGER DEFAULT (prop_std + prop_opt),
asof       IN            TIMESTAMP DEFAULT NULL,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
 
GETPATHBYMOUNTID
Undocumented dbms_dbfs_content.getPathByMountID(store_mount IN VARCHAR2, guid IN INTEGER)
RETURN VARCHAR2;
TBD
 
GETPATHBYSTOREID
Undocumented dbms_dbfs_content.getPathByStoreID(store_name IN VARCHAR2, guid IN INTEGER)
RETURN VARCHAR2;
TBD
 
GETPATHNOWAIT
Undocumented
Overload 1		 dbms_dbfs_content.getPathNoWait(
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
content       OUT NOCOPY BLOB,
item_type     OUT        INTEGER,
prop_flags IN            INTEGER  DEFAULT (prop_std + prop_opt + prop_data),
deref      IN            BOOLEAN  DEFAULT FALSE,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_dbfs_content.getPathNoWait(
path       IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
content       OUT NOCOPY BLOB,
item_type     OUT        INTEGER,
prop_flags IN            INTEGER  DEFAULT (prop_std + prop_opt + prop_data),
deref      IN            BOOLEAN  DEFAULT FALSE,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
 
GETSTATS
Enable DBFS API statistics collection

Note: Stats collection is very expensive as its their maintenance		 dbms_dbfs_content.getStats(
enabled     OUT BOOLEAN,
flush_time  OUT INTEGER,
flush_count OUT INTEGER);
TBD
 
GETSTOREBYMOUNT
Undocumented dbms_dbfs_content.getStoreByMount(store_mount IN VARCHAR2) RETURN store_t;
TBD
 
GETSTOREBYNAME
Undocumented dbms_dbfs_content.getStoreByName(store_name IN VARCHAR2) RETURN store_t;
TBD
 
GETSTOREBYPATH
Undocumented dbms_dbfs_content.getStoreByPath(path IN path_t)  RETURN store_t;
TBD
 
GETTRACE
Returns 0 if no not currently tracing dbms_dbfs_content.getTrace RETURN INTEGER;
SELECT dbms_dbfs_content.getTrace
FROM dual;
 
GETVERSION
Undocumented dbms_dbfs_content.getVersion;
SELECT dbms_dbfs_content.getVersion FROM dual;
 
LIST
Undocumented dbms_dbfs_content.list(
path       IN VARCHAR2,
filter     IN VARCHAR2  DEFAULT NULL,
recurse    IN INTEGER   DEFAULT 0,
asof       IN TIMESTAMP DEFAULT NULL,
store_name IN VARCHAR2  DEFAULT NULL,
principal  IN VARCHAR2  DEFAULT NULL)
RETURN dbms_dbfs_content_list_items_t PIPELINED;
TBD
 
LISTALLCONTENT
Content view support dbms_dbfs_content.listAllContent RETURN path_items_t PIPELINED;
SQL> SELECT * FROM TABLE(dbms_dbfs_content.listallcontent);

SP2-0678: Column or attribute type can not be displayed by SQL*Plus
 
LISTALLPROPERTIES
Properties view support dbms_dbfs_content.listAllProperties RETURN prop_items_t PIPELINED;
SELECT * FROM TABLE(dbms_dbfs_content.listallproperties);
 
LISTCURSOR (new 11.2.0.2)
A highly specialized directory enumerator that is meant for use with "dbms_fuse" and "dbfs_client" as callers, and with "dbms_dbfs_sfs.listCursor" as the callee dbms_dbfs_content.listCursor(
path      IN VARCHAR2,
withProps IN INTEGER DEFAULT 0,
doSort    IN INTEGER DEFAULT 0,
doFts     IN INTEGER DEFAULT 0,
doBulk    IN INTEGER DEFAULT 0)
RETURN INTEGER;
TBD
 
LISTMOUNTS
Undocumented dbms_dbfs_content.listMounts RETURN mounts_t PIPELINED;
TBD
 
LISTSTORES
List stores and their features dbms_dbfs_content.listStores RETURN stores_t PIPELINED;
TBD
 
LOCKPATH
apply user-level locks to any valid pathname (subject to store feature support) dbms_dbfs_content.lockPath(
path       IN VARCHAR2,
lock_type  IN INTEGER  DEFAULT lock_read_only,
lock_data  IN VARCHAR2 DEFAULT NULL,
store_name IN VARCHAR2 DEFAULT NULL,
principal  IN VARCHAR2 DEFAULT NULL);
TBD
 
MOUNTSTORE
Mount a registered store "store_name" and bind it to the "store_mount" mount-point dbms_dbfs_content.mountStore(
store_name  IN VARCHAR2,
store_mount IN VARCHAR2  DEFAULT NULL,
singleton   IN BOOLEAN   DEFAULT FALSE,
principal   IN VARCHAR2  DEFAULT NULL,
owner       IN VARCHAR2  DEFAULT NULL,
acl         IN VARCHAR2  DEFAULT NULL,
asof        IN TIMESTAMP DEFAULT NULL,
read_only   IN BOOLEAN   DEFAULT FALSE,
view_name   IN VARCHAR2  DEFAULT NULL);
TBD
 
MOVEPATH (new 11.2.0.3)
Change the path of a DBFS store

Overload 1		 dbms_dbfs_content.movePath(
oldpath    IN            VARCHAR2,
newpath    IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_content_properties_t,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_dbfs_content.movePath(
oldpath    IN            VARCHAR2,
newpath    IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL
TBD
 
NORMALIZEPATH (new overload in 11.2.0.2)
Convert a store-specific or full-absolute pathname into normalized form: -> verifies that the pathname is absolute, i.e. starts with a "/".

Overload 1		 dbms_dbfs_content.normalizePath(
path   IN  VARCHAR2,
parent OUT NOCOPY VARCHAR2,
tpath  OUT NOCOPY VARCHAR2)
RETURN VARCHAR2;
TBD
Overload 2 dbms_dbfs_content.normalizePath(
path       IN  VARCHAR2,
store_name OUT NOCOPY VARCHAR2,
parent     OUT NOCOPY VARCHAR2,
tpath      OUT NOCOPY VARCHAR2)
RETURN VARCHAR2;
TBD
Overload 3 dbms_dbfs_content.normalizePath(
path       IN  VARCHAR2,
forWrite   IN  INTEGER,
store_name OUT NOCOPY VARCHAR2,
parent     OUT NOCOPY VARCHAR2,
tpath      OUT NOCOPY VARCHAR2,
provider   OUT NOCOPY VARCHAR2,
ctx        OUT NOCOPY dbms_dbfs_content_context_t)
RETURN VARCHAR2;
TBD
 
PROPANY
Simple Property Constructor

Overload 1		 dbms_dbfs_content.propany(val IN NUMBER) RETURN property_t;
TBD
Simple Property Constructor

Overload 2		 dbms_dbfs_content.propany(val IN VARCHAR2) RETURN property_t;
TBD
Simple Property Constructor

Overload 3		 dbms_dbfs_content.propany(val IN TIMESTAMP) RETURN property_t;
TBD
Simple Property Constructor

Overload 4		 dbms_dbfs_content.propany(val IN RAW) RETURN property_t;
TBD
 
PROPERTIESH2T
Hash to table: convert a properties_t into a dbms_dbfs_content_properties_t dbms_dbfs_content.propertiesH2T(pprops IN properties_t)
RETURN dbms_dbfs_content_properties_t;
TBD
 
PROPERTIEST2H
Convert table to hash: convert a dbms_dbfs_content_properties_t to a property_t dbms_dbfs_content.propertiesT2H(sprops IN dbms_dbfs_content_properties_t)
RETURN properties_t;
TBD
 
PROPNUMBER
Simple Property Constructor dbms_dbfs_content.propNumber(val IN NUMBER) RETURN property_t;
TBD
 
PROPRAW
Simple Property Constructor dbms_dbfs_content.propRaw(val IN RAW) RETURN property_t;
TBD
 
PROPTIMESTAMP
Simple Property Constructor dbms_dbfs_content.propTimestamp(val IN TIMESTAMP) RETURN property_t;
TBD
 
PROPVARCHAR2
Simple Property Constructor dbms_dbfs_content.propVarchar2(val IN VARCHAR2) RETURN property_t;
TBD
 
PURGEALL
Purges all dbms_dbfs_content.purgeAll(
path       IN VARCHAR2,
filter     IN VARCHAR2 DEFAULT NULL,
store_name IN VARCHAR2 DEFAULT NULL,
principal  IN VARCHAR2 DEFAULT NULL);
TBD
 
PURGEPATH
Purge the specified path dbms_dbfs_content.purgePath(
path       IN VARCHAR2,
filter     IN VARCHAR2 DEFAULT NULL,
store_name IN VARCHAR2 DEFAULT NULL,
principal  IN VARCHAR2 DEFAULT NULL);
TBD
 
PUTPATH
Undocumented

Overload 1		 dbms_dbfs_content.putPath(
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  DEFAULT (prop_std + prop_opt + prop_data),
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_dbfs_content.putPath(
path       IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
content    IN OUT NOCOPY BLOB,
item_type     OUT        INTEGER,
prop_flags IN            INTEGER  DEFAULT (prop_std + prop_opt + prop_data),
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 3 dbms_dbfs_content.putPath(
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  DEFAULT (prop_std + prop_opt),
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 4 dbms_dbfs_content.putPath(
path       IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
amount     IN            NUMBER,
offset     IN            NUMBER,
buffer     IN            RAW,
prop_flags IN            INTEGER DEFAULT (prop_std + prop_opt),
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 5 dbms_dbfs_content.putPath(
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  DEFAULT (prop_std + prop_opt),
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 6 dbms_dbfs_content.putPath(
path       IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
written       OUT        NUMBER,
offset     IN            NUMBER,
buffers    IN            dbms_dbfs_content_RAW_t,
prop_flags IN            INTEGER  DEFAULT (prop_std + prop_opt),
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
 
REGISTERSTORE
Register a new store "store_name" backed by provider "provider_name" that uses "provider_package" as the store provider (conforming to the "dbms_dbfs_content_spi" package signature) dbms_dbfs_content.registerStore(
store_name       IN VARCHAR2,
provider_name    IN VARCHAR2,
provider_package IN VARCHAR2);
TBD
 
REMOUNTALL (new 11.2.0.3)
Remount all DBFS stores dbms_dbfs_content.remountAll;
exec dbms_dbfs_content.remountAll;
 
REMOUNTSTORE (new 11.2.0.3)
Remount an existing DBFS store dbms_dbfs_content.remountStore(
store_name     IN VARCHAR2 DEFAULT NULL,
store_mount    IN VARCHAR2 DEFAULT NULL,
ignore_unknown IN BOOLEAN  DEFAULT FALSE);
TBD
 
RENAMEPATH
Rename a store path

Overload 1		 dbms_dbfs_content.renamePath(
oldPath    IN            VARCHAR2,
newPath    IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_dbfs_content.renamePath(
oldPath    IN            VARCHAR2,
newPath    IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
store_name IN            VARCHAR2 DEFAULT NULL,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
 
RESTOREALL
Undocumented dbms_dbfs_content.restoreAll(
path       IN VARCHAR2,
filter     IN VARCHAR2 DEFAULT NULL,
store_name IN VARCHAR2 DEFAULT NULL,
principal  IN VARCHAR2 DEFAULT NULL);
TBD
 
RESTOREPATH
Undocumented dbms_dbfs_content.restorePath(
path       IN VARCHAR2,
filter     IN VARCHAR2 DEFAULT NULL,
store_name IN VARCHAR2 DEFAULT NULL,
principal  IN VARCHAR2 DEFAULT NULL);
TBD
 
SEARCH
Search the contents of a directory path dbms_dbfs_content.search(
path       IN VARCHAR2,
filter     IN VARCHAR2  DEFAULT NULL,
recurse    IN INTEGER   DEFAULT 0,
asof       IN TIMESTAMP DEFAULT NULL,
store_name IN VARCHAR2  DEFAULT NULL,
principal  IN VARCHAR2  DEFAULT NULL)
RETURN dbms_dbfs_content_list_items_t PIPELINED;
TBD
 
SETDEFAULTACL
Undocumented dbms_dbfs_content.setDefaultACL(acl IN VARCHAR2);
TBD
 
SETDEFAULTASOF
Undocumented dbms_dbfs_content.setDefaultAsOf(asof IN TIMESTAMP);
TBD
 
SETDEFAULTCONTEXT
Undocumented dbms_dbfs_content.setDefaultContext(
principal OUT NOCOPY VARCHAR2,
owner     OUT NOCOPY VARCHAR2,
acl       OUT NOCOPY VARCHAR2,
asof      OUT        TIMESTAMP);
TBD
 
SETDEFAULTOWNER
Set the DEFAULT store owner dbms_dbfs_content.setDefaultOwner(owner IN VARCHAR2);
TBD
 
SETDEFAULTPRINCIPAL
Undocumented dbms_dbfs_content.setDefaultPrincipal(principal IN VARCHAR2);
TBD
 
SETPATH
Undocumented

Overload 1		 dbms_dbfs_content.setPath(
store_name IN            VARCHAR2,
contentID  IN            RAW,
path       IN            VARCHAR2,
properties IN OUT NOCOPY dbms_dbfs_content_properties_t,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_dbfs_content.setPath(
store_name IN            VARCHAR2,
contentID  IN            RAW,
path       IN            VARCHAR2,
properties IN OUT NOCOPY properties_t,
principal  IN            VARCHAR2 DEFAULT NULL);
TBD
 
SETSTATS
Disable DBFS API statistics collection dbms_dbfs_content.setStats(
enable      IN BOOLEAN,
flush_time  IN INTEGER DEFAULT NULL,
flush_count IN INTEGER DEFAULT NULL);
TBD
 
SETTRACE
Undocumented dbms_dbfs_content.setTrace(trclvl IN INTEGER);
TBD
 
SPACEUSAGE (new parameter in 11.2.0.2)
Query file system space usage statistics

Overload 1		 dbms_dbfs_content.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);
TBD
Overload 2 dbms_dbfs_content.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
 
TRACE
Undocumented dbms_dbfs_content.trace(
sev   IN INTEGER,
msg0  IN VARCHAR2,
msg1  IN VARCHAR DEFAULT '',
msg2  IN VARCHAR DEFAULT '',
msg3  IN VARCHAR DEFAULT '',
msg4  IN VARCHAR DEFAULT '',
msg5  IN VARCHAR DEFAULT '',
msg6  IN VARCHAR DEFAULT '',
msg7  IN VARCHAR DEFAULT '',
msg8  IN VARCHAR DEFAULT '',
msg9  IN VARCHAR DEFAULT '',
msg10 IN VARCHAR DEFAULT '');
TBD
 
TRACEENABLED
Undocumented dbms_dbfs_content.traceEnabled(sev IN INTEGER) RETURN INTEGER;
set serveroutput on

DECLARE
 x INTEGER;
BEGIN
  x := dbms_dbfs_content.traceEnabled(2);
  dbms_output.put_line(x);
END;
/
 
UNLOCKPATH
Undocumented dbms_dbfs_content.unlockPath(
path       IN VARCHAR2,
store_name IN VARCHAR2 DEFAULT NULL,
principal  IN VARCHAR2 DEFAULT NULL);
TBD
 
UNMOUNTALL (new 11.2.0.3)
Unmount all DBFS stores dbms_dbfs_content.unmountAll;
exec dbms_dbfs_content.unmountAll;
 
UNMOUNTSTORE
Undocumented dbms_dbfs_content.unmountStore(
store_name     IN VARCHAR2 DEFAULT NULL,
store_mount    IN VARCHAR2 DEFAULT NULL,
ignore_unknown IN BOOLEAN DEFAULT FALSE);
TBD
 
UNREGISTERSTORE
Undocumented dbms_dbfs_content.unregisterStore(
store_name     IN VARCHAR2,
ignore_unknown IN BOOLEAN DEFAULT FALSE);
TBD
 
Related Topics
DBMS_APBACKEND
DBMS_DBFS_CONTENT_ADMIN
DBMS_DBFS_CONTENT_SPI
DBMS_DBFS_HS
DBMS_DBFS_SFS
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