Oracle | DBMS_DBFS_CONTENT

Oracle DBMS_DBFS_CONTENT_ADMIN Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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 and OGG_APPLY_PROCREP roles.

Source {ORACLE_HOME}/rdbms/admin/dbmscapi.sql

See also: {ORACLE_HOME}/rdbms/admin/dbfs_create_filesystem_advanced.sql

Subprograms

CHECKSPI	PROFILE_CLEAR	SYSTEM_INFO_EXP
EXIMREGISTERALL	PROFILE_DMP_ENABLE	UNMOUNTSTORE
EXIM_MOUNT	PROFILE_DMP_RESTORE	UNMOUNTSTORE_LOG
EXIM_MOUNTP	PROFILE_ENABLE	UNREGISTERCLIENT
EXIM_STORE	PROFILE_RESTORE	UNREGISTERSTORE
INSTANCE_INFO_EXP	REGISTERCLIENT	UNREGISTERSTORE_LOG
LISTCLIENTS	REGISTERSTORE	UPDATECTX
MOUNTSTORE	REGISTERSTORE_LOG	UPDATESTATS
MOUNTSTORE_LOG	SCHEMA_INFO_EXP

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_DMP_ENABLE (new 23ai)

Undocumented dbms_dbfs_content_admin.profile_dmp_enable;

exec dbms_dbfs_content_admin.profile_dmp_enable;

PROFILE_DMP_RESTORE (new 23ai)

Undocumented dbms_dbfs_content_admin.profile_dmp_restore;

exec dbms_dbfs_content_admin.profile_dmp_restore;

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 (new 23ai parameter)

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, suid 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 (new 23ai parameter)

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( suid IN VARCHAR2, 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 (new 23ai parameter)

Unregister a previously registered store invalidating all associated mount-points dbms_dbfs_content_admin.unregisterStore( store_name IN VARCHAR2, suid IN VARCHAR2, ignore_unknown IN BOOLEAN DEFAULT FALSE, store_owner IN VARCHAR2 DEFAULT NULL, force 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 (new 23ai parameter)

Internal helper function that modifies the DBFS context and allows sessions to refresh their internal state on subsequent operations dbms_dbfs_content_admin.updateCtx(suid IN VARCHAR2 DEFAULT NULL);

exec dbms_dbfs_content_admin.updateCtx;

UPDATESTATS (new 23ai parameter)

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, suid IN VARCHAR2);

TBD