Oracle DBMS_XDBREPOS
Version 21c

General Information
Purpose Functions for creating new repositories. A repository is a self-contained unit that manages path based access to content. Repositories can be customized to support ACLs, versioning, event handlers etc.

Based on a number of factors, the description, above, not matching the capabilities, the lack of documentation even though execute is granted to PUBLIC, the response to any value thrown at CreateRepository as an option value, and the fact that none is created by default it is highly likely that this package has not yet been completed and should never have been included in the build.
AUTHID CURRENT_USER
Constants
Name Data Type Value
ACL_SECURITY NUMBER 1
EVENTS NUMBER 2
VERSIONING NUMBER 4
CONFIG_FILE NUMBER 8
DOCUMENT_LINKS NUMBER 16
NFS_LOCKS NUMBER 32
FULL_FEATURED NUMBER 63
Dependencies
DBMS_ASSERT DBMS_XDB_LIB XDB$STRING_LIST_T
DBMS_STANDARD PLITBLM  
Documented No
Exceptions
Error Code Reason
ORA-27476 Repository does not exist
ORA-31093 Null or invalid value specified for parameter : reposOptions
First Available 1996
Security Model Owned by XDB with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmsxdbrepos.sql
Subprograms
 
CREATEREPOSITORY
Creates a self-contained modular repository dbms_xdbrepos.CreateRepository(
reposOwner   IN VARCHAR2,
reposName    IN VARCHAR2,
reposOptions IN PLS_INTEGER); -- undocumented parameter ... tested many values
desc xdb.xdb$repos

SELECT COUNT(*)
FROM xdb.xdb$repos;

exec xdb.dbms_xdbrepos.createRepository('UCLASS', 'UW_XDB', 42);

BEGIN xdb.dbms_xdbrepos.createRepository('UCLASS', 'UW_XDB', 42); END;
*
ERROR at line 1:
ORA-31093: null or invalid value specified for parameter : reposOptions
ORA-06512: at "XDB.DBMS_XDBREPOS", line 178
ORA-06512: at line 1
 
DROPREPOSITORY
Drop repository and contents dbms_xdbrepos.DropRepository(
reposOwner IN VARCHAR2,
reposName  IN VARCHAR2);
exec xdb.dbms_xdbrepos.dropRepository('UCLASS', 'UW_XDB');
 
DROP_REPOS
Undocumented dbms_xdbrepos.Drop_Repos(schema IN VARCHAR2, tables IN XDB$STRING_LIST_T);
TBD
 
INSTALL_REPOS
Undocumented dbms_xdbrepos.Install_Repos(schema IN VARCHAR2, tables IN XDB$STRING_LIST_T);
TBD
 
MOUNTREPOSITORY
Mounts the specified repository at a given path in source repository dbms_xdbrepos.MountRepository(
parentReposOwner  IN VARCHAR2,
parentReposName   IN VARCHAR2,
parentMntPath     IN VARCHAR2,
mountedReposOwner IN VARCHAR2,
mountedReposName  IN VARCHAR2,
mountedPath       IN VARCHAR2);
TBD
 
SETCURRENTREPOSITORY
Sets the current repository for all operations dbms_xdbrepos.SetCurrentRepository(
reposOwner IN VARCHAR2,
reposName  IN VARCHAR2);
exec xdb.dbms_xdbrepos.setCurrentRepository('UCLASS', 'UW_XDB');
 
UNMOUNTREPOSITORY
Unmounts the identified repository dbms_xdbrepos.UnmountRepository(
parentReposOwner IN VARCHAR2,
parentReposName  IN VARCHAR2,
mountPath        IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_XDB
DBMS_XDBRESOURCE
DBMS_XDB_ADMIN
DBMS_XLSB
What's New In 21c
What's New In 23c

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