Oracle DBMS_DBFS_CONTENT_ADMIN
Version 19.3

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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_XSTREAM_GG
ALL_PROCEDURES DBMS_DBFS_CONTENT_PROPERTIES_T DUAL
DBFS$_CLIENTS DBMS_DBFS_CONTENT_PROPERTY_T EXPPKGACT$
DBFS$_MOUNTS DBMS_DBFS_SFS_ADMIN GV$SESSION
DBFS$_STATS DBMS_DB_VERSION PLITBLM
DBFS$_STORES DBMS_LOB UTL_RAW
DBMS_ARCH_PROVIDER_INTL DBMS_SESSION X$KSPPCV
DBMS_ASSERT DBMS_TYPES X$KSPPI
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
 
LISTCLIENTS (new 18c)
Undocumented dbms_dbfs_content_admin.listClients RETURN dbms_dbfs_content.clients_t PIPELINED;
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
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
 
PROFILE_CLEAR
Undocumented dbms_dbfs_content_admin.profile_clear;
exec dbms_dbfs_content_admin.profile_clear;
 
PROFILE_ENABLE
Undocumented dbms_dbfs_content_admin.profile_enable;
exec dbms_dbfs_content_admin.profile_enable;
 
PROFILE_RESTORE
Undocumented dbms_dbfs_content_admin.profile_restore;
exec dbms_dbfs_content_admin.profile_restore;
 
REGISTERCLIENT
Undocumented. Client info must be unique and should be correlated with the client_info column in v$session using dbms_application_info.set_client_info. dbms_dbfs_content_admin.registerClient(
client_info IN VARCHAR2,
client_data IN VARCHAR2 DEFAULT NULL);
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
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
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
 
UNREGISTERCLIENT
Undocumented dbms_dbfs_content_admin.unregisterClient(client_info IN VARCHAR2);
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
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
Built-in Functions
Built-in Packages
DBMS_APBACKEND
DBMS_DBFS_CONTENT
DBMS_DBFS_CONTENT_SPI
DBMS_DBFS_HS
DBMS_DBFS_SFS
DBMS_DBFS_SFS_ADMIN
DBMS_SPACE
What's New IN 18cR3
What's New IN 19cR3

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