| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsxrc.sql |
| First Available |
10.2 |
| Constants |
| Name |
Data Type |
Value |
| DELETE_RESOURCE |
NUMBER |
1 |
| DELETE_RECURSIVE |
NUMBER |
2 |
| APPEND_RESOURCE |
NUMBER |
1 |
| APPEND_RECURSIVE |
NUMBER |
2 |
|
| Dependencies |
| DBMS_NETWORK_ACL_ADMIN |
RESOURCE_VIEW |
XMLTYPE |
| DBMS_RC_LIB |
XDB$RCLIST_V |
|
| PLITBLM |
XDB$STRING_LIST_T |
|
|
| Security Model |
Execute is granted to PUBLIC. Created with AUTHID CURRENT_USER |
| Subprograms |
|
| |
| ADDREPOSITORYRESCONFIG |
| Inserts the resource configuration specified by rcpath at the given position of the repository's configuration list.
Shifts the element currently at that position (if any) and any subsequent elements to the right. |
dbms_resconfig.addrepositoryresconfig(rcpath IN VARCHAR2, pos IN PLS_INTEGER := NULL); |
| exec dbms_ResConfig.AddRepositoryResConfig('/sys/xs/morgan.xml', 20); |
| |
| ADDRESCONFIG |
| Inserts the resource configuration specified by rcpath at the given position in the target resource's configuration list |
dbms_resconfig.addresconfig(
respath IN VARCHAR2,
rcpath IN VARCHAR2,
pos IN PLS_INTEGER := NULL); |
| TBD |
| |
| APPENDRESCONFIG |
|
Appends the resource configuration specified by rcpath to the target resource's configuration list if it is not already included in the list |
dbms_resconfig.appendresconfig(
respath IN VARCHAR2,
rcpath IN VARCHAR2,
appendOption IN PLS_INTEGER); |
| TBD |
| |
| DELETEREPOSITORYRESCONFIG |
Removes the configuration at the given position in the repository's configuration list. Shifts any subsequent elements to the left.
Users must have XDBADMIN role to execute this. This statement is treated as if it is a DDL statement.
This means the system will implicitly commit before and after this statement.
Warning: Running this statement, as shown, is destructive. Demo only. |
dbms_resconfig.deleteRepositoryResConfig(pos IN PLS_INTEGER); |
-- found in xse102.sql
BEGIN
dbms_ResConfig.DeleteRepositoryResConfig(6);
dbms_ResConfig.DeleteRepositoryResConfig(5);
dbms_ResConfig.DeleteRepositoryResConfig(4);
dbms_ResConfig.DeleteRepositoryResConfig(3);
dbms_ResConfig.DeleteRepositoryResConfig(2);
dbms_ResConfig.DeleteRepositoryResConfig(1);
dbms_ResConfig.DeleteRepositoryResConfig(0);
END;
/ |
| |
| DELETERESCONFIG |
Removes the configuration at the given position in the target resource's configuration list
Overload 1
Warning: Running this statement, as shown, is destructive. Demo only. |
dbms_resconfig.deleteresconfig(respath IN VARCHAR2, pos IN PLS_INTEGER); |
| exec dbms_resconfig.deleteresconfig('/sys/xs', 9); |
Removes the configuration specified by rcpath from the target resource's configuration list.
Shifts any subsequent elements to the left. Users must have write-config privilege on all affected resources to execute this.
Overload 2 |
dbms_resconfig.deleteresconfig(
respath IN VARCHAR2,
rcpath IN VARCHAR2,
deleteOption IN PLS_INTEGER); |
| TBD |
| |
| GETLISTENERS |
| Returns an XML doc containing the list of listeners applicable for a given resource |
dbms_resconfig.getlisteners(path IN VARCHAR2) RETURN SYS.XMLType; |
| SELECT dbms_resconfig.getlisteners('/sys/xs') FROM dual; |
| |
| GETREPOSITORYRESCONFIG |
| Returns the resource configuration at the specified position of the repository's configuration list |
dbms_resconfig.getRepositoryResConfig(pos IN PLS_INTEGER) RETURN SYS.XMLType; |
| SELECT dbms_resconfig.getRepositoryResConfig(0) FROM dual; |
| |
| GETREPOSITORYRESCONFIGPATHS |
| Returns a list of resource configuration paths defined for the repository |
dbms_resconfig.getrepositoryresconfigpaths RETURN XDB$STRING_LIST_T; |
SELECT * FROM TABLE(dbms_resconfig.getRepositoryResConfigPaths());
DECLARE
out_list xdb$string_list_t := dbms_resconfig.getRepositoryResConfigPaths();
BEGIN
FOR i in 1..out_list.COUNT LOOP
dbms_output.put_line(out_list(i));
END LOOP;
END;
/ |
| |
| GETRESCONFIG |
| Returns the resource configuration at the specified position of the target resource's configuration list. |
dbms_resconfig.getresconfig(respath IN VARCHAR2, pos IN PLS_INTEGER)
RETURN sys.XMLType; |
| SELECT dbms_resconfig.getresconfig('/sys/xs', 4) FROM dual; |
| |
| GETRESCONFIGPATHS |
| Returns a list of resource configuration paths defined in the target resource's configuration list |
dbms_resconfig.getresconfigpaths(respath IN VARCHAR2) RETURN XDB$STRING_LIST_T; |
| SELECT dbms_resconfig.getresconfigpaths('/sys/xs') FROM dual; |
| |
| Related Queries |
| Found in xse102.sql |
SELECT ANY_PATH p FROM RESOURCE_VIEW
WHERE under_path(RES, '/sys/xs', 1) = 1
ORDER BY depth(1) DESC; |
