Oracle DBMS_DBFS_CONTENT_ADMIN
Version 12.1.0.1

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 The administrative methods in "dbms_dbfs_content" are wrappers that delegate to the matching methods in dbms_dbfs_content_admin". Clients can use the methods in either package to perform administrative operations.
AUTHID DEFINER
Dependencies
ALL_ARGUMENTS DBMS_DBFS_CONTENT DBMS_TYPES
ALL_PROCEDURES DBMS_DBFS_CONTENT_PROPERTIES_T DUAL
DBFS$_MOUNTS DBMS_DBFS_CONTENT_PROPERTY_T EXPPKGACT$
DBFS$_STATS DBMS_DBFS_SFS_ADMIN PLITBLM
DBFS$_STORES DBMS_DB_VERSION SYS_STUB_FOR_PURITY_ANALYSIS
DBMS_ARCH_PROVIDER_INTL DBMS_LOB UTL_RAW
DBMS_ASSERT DBMS_SESSION  
Documented No
First Available 11.1.0.6
Security Model Owned by SYS with EXECUTE granted to the DBFS_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmscapi.sql

See also: {ORACLE_HOME}/rdbms/admin/dbfs_create_filesystem_advanced.sql
Subprograms
 
CHECKSPI
Checks that the package really implements all provider methods (with the proper signatures), and reports conformance. The result is generated into the "chk" lob dbms_dbfs_content_admin.checkspi(
schema_name  IN            VARCHAR2,
package_name IN            VARCHAR2,
chk          IN OUT NOCOPY CLOB);
TBD
 
EXIMREGISTERALL
A one-time action to register the ContentAPI entities with the procedural action infrastructure dbms_dbfs_content_admin.eximRegisterAll;
exec dbms_dbfs_content_admin.eximRegisterAll;
 
EXIM_MOUNT
DBFS export/import support (helper functions). These functions are _strictly_ for internal use in the DBFS export/import infrastructure.

Do not even think about using them explicitly.
dbms_dbfs_content_admin.exim_mount(
s_owner IN VARCHAR2,
s_name  IN VARCHAR2,
s_mount IN VARCHAR2,
created IN NUMBER);
TBD
 
EXIM_MOUNTP
DBFS export/import support (helper functions). These functions are _strictly_ for internal use in the DBFS export/import infrastructure.

Do not even think about using them explicitly.
dbms_dbfs_content_admin.exim_mountp(
s_owner   IN VARCHAR2,
s_name    IN VARCHAR2,
s_mount   IN VARCHAR2,
propname  IN VARCHAR2,
propvalue IN VARCHAR2,
typecode  IN NUMBER);
TBD
 
EXIMSTORE
DBFS export/import support (helper functions). These functions are _strictly_ for internal use in the DBFS export/import infrastructure.

Do not even think about using them explicitly.
dbms_dbfs_content_admin.exim_store(
s_owner IN VARCHAR2,
s_name  IN VARCHAR2,
p_name  IN VARCHAR2,
p_pkg   IN VARCHAR2,
created IN NUMBER);
TBD
 
INSTANCE_INFO_EXP
DBFS export/import procedural actions dbms_dbfs_content_admin.instance_info_exp(
name      IN  VARCHAR2,
schema    IN  VARCHAR2,
prepost   IN  PLS_INTEGER,
isdba     IN  PLS_INTEGER,
version   IN  VARCHAR2,
new_block OUT PLS_INTEGER)
RETURN VARCHAR2;
TBD
 
MOUNTSTORE
Mount a registered store "store_name" and bind it to the "store_mount" mount-point dbms_dbfs_content_admin.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);
exec dbms_dbfs_content.registerStore('MY_TBFS', 'table', 'UWCLASS');
exec dbms_dbfs_content.mountStore('MY_TBFS', singleton => TRUE);
 
MOUNTSTORE_LOG (new 12.1)
Undocumented dbms_dbfs_content_admin.mountStore_log(
store_name  IN VARCHAR2,
store_mount IN VARCHAR2,
singleton   IN BOOLEAN,
principal   IN VARCHAR2,
owner       IN VARCHAR2,
acl         IN VARCHAR2,
asof        IN TIMESTAMP,
read_only   IN BOOLEAN,
view_name   IN VARCHAR2,
suid        IN VARCHAR2,
ctime       IN TIMESTAMP);
TBD
 
REGISTERSTORE
Register a new store 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_admin.registerStore(
store_name       IN VARCHAR2,
provider_name    IN VARCHAR2,
provider_package IN VARCHAR2);
See mountStore Demo Above
 
REGISTERSTORE_LOG (new 12.1)
Undocumented dbms_dbfs_content_admin.registerStore_log(
store_name       IN VARCHAR2,
provider_name    IN VARCHAR2,
provider_package IN VARCHAR2,
suid             IN VARCHAR2,
ctime            IN TIMESTAMP);
TBD
 
SCHEMA_INFO_EXP
DBFS export/import procedural actions dbms_dbfs_content_admin.schema_info_exp(
schema    IN  VARCHAR2,
prepost   IN  PLS_INTEGER,
isdba     IN  PLS_INTEGER,
version   IN  VARCHAR2,
new_block OUT PLS_INTEGER)
RETURN VARCHAR2;
TBD
 
SYSTEM_INFO_EXP
DBFS export/import procedural actions dbms_dbfs_content_admin.system_info_exp(
prepost       IN         PLS_INTEGER,
connectstring OUT NOCOPY VARCHAR2,
version       IN         VARCHAR2,
new_block     OUT        PLS_INTEGER)
RETURN VARCHAR2;
TBD
 
UNMOUNTSTORE
Unmount a previously mounted store, either by name or by mount point. Single stores can be unmounted only by store name (since they have no mount-points) dbms_dbfs_content_admin.unMountStore(
store_name     IN VARCHAR2 DEFAULT NULL,
store_mount    IN VARCHAR2 DEFAULT NULL,
ignore_unknown IN BOOLEAN DEFAULT FALSE);
TBD
 
UNMOUNTSTORE_LOG (new 12.1)
Undocumented dbms_dbfs_content_admin.unmountStore_log(
store_name     IN VARCHAR2,
store_mount    IN VARCHAR2,
ignore_unknown IN BOOLEAN,
suid           IN VARCHAR2,
ctime          IN TIMESTAMP);
TBD
 
UNREGISTERSTORE
Unregister a previously registered store invalidating all mount-points associated with it dbms_dbfs_content_admin.unregisterStore(
store_name     IN VARCHAR2,
ignore_unknown IN BOOLEAN DEFAULT FALSE);
TBD
 
UNREGISTERSTORE_LOG (new 12.1)
Undocumented dbms_dbfs_content_admin.unregisterStore_log(
store_name     IN VARCHAR2,
ignore_unknown IN BOOLEAN,
suid           IN VARCHAR2,
ctime          IN TIMESTAMP);
TBD
 
UPDATECTX
Internal helper function that modifies the DBFS context and allows sessions to refresh their internal state on subsequent operations dbms_dbfs_content_admin.updateCtx;
exec dbms_dbfs_content_admin.updateCtx;
 
UPDATESTATS
Update operation statistics for a store/mount.

Statistics flushes are invoked by the DBFS API operations, and update the common metadata tables IN a secure manner.
dbms_dbfs_content_admin.updateStats(
store_name  IN VARCHAR2,
store_mount IN VARCHAR2,
op          IN INTEGER,
cnt         IN INTEGER,
wt          IN INTEGER,
ct          IN INTEGER);
TBD

Related Topics
DBMS_APBACKEND
DBMS_DBFS_CONTENT
DBMS_DBFS_CONTENT_SPI
DBMS_DBFS_HS
DBMS_DBFS_SFS
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