Oracle DBMS_XDBREPOS
Version 12.1.0.2

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
DEBUG_MODE NUMBER 0
Dependencies
DBMS_ASSERT PLITBLM XDB$STRING_LIST_T
DBMS_XDB_LIB    
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
DBMS_XDB
DBMS_XDB_ADMIN
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