Oracle | DBMS_DBFS_CONTENT

Oracle DBMS_DBFS_CONTENT_ADMIN Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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
DBA_USERS	DBMS_DBFS_CONTENT_PROPERTY_T	EXPPKGACT$
DBFS$_CLIENTS	DBMS_DBFS_SFS_ADMIN	GV$SESSION
DBFS$_MOUNTS	DBMS_DB_VERSION	PLITBLM
DBFS$_STATS	DBMS_FUSE_PUBLIC	UTL_RAW
DBFS$_STORES	DBMS_LOB	X$KSPPCV
DBMS_ARCH_PROVIDER_INTL	DBMS_SESSION	X$KSPPI
DBMS_ASSERT	DBMS_TYPES

Documented No

First Available 11.1

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	MOUNTSTORE_LOG	SYSTEM_INFO_EXP
EXIMREGISTERALL	PROFILE_CLEAR	UNMOUNTSTORE
EXIM_MOUNT	PROFILE_ENABLE	UNMOUNTSTORE_LOG
EXIM_MOUNTP	PROFILE_RESTORE	UNREGISTERCLIENT
EXIM_STORE	REGISTERCLIENT	UNREGISTERSTORE
INSTANCE_INFO_EXP	REGISTERSTORE	UNREGISTERSTORE_LOG
LISTCLIENTS	REGISTERSTORE_LOG	UPDATECTX
MOUNTSTORE	SCHEMA_INFO_EXP	UPDATESTATS

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

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