Oracle | DBMS_XDBUTIL

Oracle DBMS_XDBUTIL_INT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal XDB Utilities

AUTHID CURRENT_USER

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_XDBUTIL_INT' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_XDBUTIL_INT' ORDER BY 1;

Returns 55 objects

Documented No

First Available Not known

Security Model Owned by XDB with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvtxdb0.plb

Subprograms

CLEANSGAFORUPGRADE	GET_TABLESPACE_TAB	NUMTOHEX2
CLEANUP_EXPIRED_NFSCLIENTS	IMPORTSEQUENCE	PATCHREPOSITORYRESCONFIGLIST
CREATEACL	INSTANCE_CALLOUT_IMP	RAWTONUM
CREATESYSTEMVIRTUALFOLDER	INSTANCE_EXPORT_ACTION	RAWTONUM2
FIXACL	ISOBJECTGENERATED	SETLINKPARENTS
FIXACL_DOWNGRADE	ISTABLEOUTOFLINE	SETLINKPARENTSNEW
FLUSHSESSION	ISXMLNESTEDTABLE	SYSTEM_INFO_EXP
GETCOMPILEDSCHEMA	LOOKUPSCHEMAOID	USESETLINKPARENTSNEW
GETCOMPILEDSCHEMABYID	LOOKUPSCHEMAURL	XMLSCHEMADEPENDENCYLEVEL
GETCSXSCHEMA	MIGRATEALLXMLFROM9201	XMLSCHEMAGETDEPENDENCYLIST
GETNAMESPACE	NUMTOHEX	XMLSCHEMASTRIPUSERNAME
GETNEWOID

CLEANSGAFORUPGRADE

Undocumented dbms_xdbutil_int.cleanSGAForUpgrade;

exec dbms_xdbutil_int.cleansgaforupgrade;

      

      PL/SQL procedure successfully completed.

CLEANUP_EXPIRED_NFSCLIENTS

Undocumented dbms_xdbutil_int.cleanup_expired_nfsClients;

exec dbms_xdbutil_int.cleanup_expired_nfsclients;

      

      PL/SQL procedure successfully completed.

CREATEACL

Create Access Control List dbms_xdbutil_int.createACL( acl_path IN VARCHAR2, objid IN RAW, data IN XMLTYPE) RETURN BOOLEAN;

TBD

CREATESYSTEMVIRTUALFOLDER

Undocumented dbms_xdbutil_int.createSystemVirtualFolder(abspath IN VARCHAR2) RETURN BOOLEAN;

-- from $ORACLE_HOME/rdbms/admin/catxdbst.sql and xdbu9202.sql

      

      Rem Create OID virtual folder

      Rem This step is repeatable.

      DECLARE

       ret BOOLEAN;

      BEGIN

        ret := dbms_xdbutil_int.createSystemVirtualFolder('/sys/oid');

        IF ret THEN

          dbms_xdb.setacl('/sys/oid', '/sys/acls/bootstrap_acl.xml');

        END IF;

      EXCEPTION

        WHEN OTHERS THEN

          ret := FALSE;

      END;

      /

      

      COMMIT;

      

      Rem Create ASM virtual folder

      Rem This step is repeatable.

      DECLARE

       ret BOOLEAN;

      BEGIN

        ret := dbms_xdbutil_int.createSystemVirtualFolder('/sys/asm');

        IF ret THEN

          dbms_xdb.setacl('/sys/asm', '/sys/acls/all_owner_acl.xml');

      END IF;

      EXCEPTION

        WHEN OTHERS THEN

          ret := FALSE;

      END;

      /

      

      COMMIT;

FIXACL

Undocumented dbms_xdbutil_int.fixACL(oldacl IN XMLTYPE) RETURN XMLTYPE;

TBD

FIXACL_DOWNGRADE

Undocumented dbms_xdbutil_int.fixACL_downGrade(oldacl IN XMLTYPE) RETURN XMLTYPE;

TBD

FLUSHSESSION

Flush the current session from memory dbms_xdbutil_int.flushSession;

exec dbms_xdbutil_int.flushSession;

      XDB FlushSession at Sun 26-Aug-2024 15:19:11

      

      PL/SQL procedure successfully completed.

GETCOMPILEDSCHEMA

Returns the schema XML based on the schema URL dbms_xdbutil_int.getCompiledSchema(schemaURL IN VARCHAR2) RETURN XMLTYPE;

SELECT dbms_xdbutil_int.getCompiledSchema('https://xmlns.oracle.com/xdb/acl.xsd');

      

      DBMS_XDBUTIL_INT.GETCOMPILEDSCHEMA('HTTPS://XMLNS.ORACLE.COM/XDB/ACL.XSD')

      --------------------------------------------------------------------------

      <?xml version="1.0" encoding="US-ASCII"?>

      <schema xmlns="https://www.w3.org/2001/XMLSchema" xmlns:xdb="https://xmlns.oracle.com/xdb" xmlns:xdbacl="https://xmlns.oracle.com/xdb/acl.xsd" targetNamespace="https://xmlns.oracle.com/ xdb/acl.xsd" version="1.0" elementFormDefault="qualified" xdb:flags="1075863861" xdb:schemaURL="https://xmlns.oracle.com/xdb/acl.xsd" xdb:schemaOwner="XDB" xdb:numProps="46" xmlns:cs x="https://xmlns.oracle.com/2004/CSX">

        <annotation>

          <documentation>

            This XML schema describes the structure of XDB ACL documents.

      ...

        <element name="write-config" type="xdbacl:privilegeNameType"

          substitutionGroup="xdbacl:privilegeName" xdb:defaultTable=""

          xmlns:csx="https://xmlns.oracle.com/2004/CSX" csx:property

          ID="2037" xdb:global="true" xdb:memType="258" xdb:defaultTableSchema="XDB"/>

      </schema>

GETCOMPILEDSCHEMABYID

Returns the schema XML based on the schema object identifier dbms_xdbutil_int.getcompiledSchemaByID(schemaOID IN RAW) RETURN XMLTYPE;

TBD

GETCSXSCHEMA

Returns the schema XML based on the CSX schema dbms_xdbutil_int.getCSXSchema(schemaDoc IN XMLTYPE) RETURN XMLTYPE;

TBD

GETNAMESPACE

Get the resolved namespace for an attribute in the list (by position) dbms_xdbutil_int.getNameSpace( schemadoc IN XMLTYPE, inde IN BINARY_INTEGER) RETURN VARCHAR2;

conn xdb/xdb

      

      set long 1000000

      

      SELECT XMLTYPE(s.getclobval())

      FROM xdb$schema s;

      

      SELECT dbms_xdbutil_int.getNamespace(XMLTYPE(s.getclobval()), 1)

      FROM xdb$schemas;

GETNEWOID

Returns an object identifier dbms_xdbutil_int.getNewOID RETURN RAW;

SELECT dbms_xdbutil_int.getNewOID;

      

      GETNEWOID

      --------------------------------

      C275128F141C4273E0531000000AFD2B

GET_TABLESPACE_TAB

Undocumented dbms_xdbutil_int.get_tablespace_tab( object_owner IN VARCHAR2, object_name IN VARCHAR2, object_subname IN VARCHAR2, object_type IN VARCHAR2) RETURN VARCHAR2;

TBD

IMPORTSEQUENCE

Undocumented dbms_xdbutil_int.importSequence( schema IN VARCHAR2, sequence IN VARCHAR2, value IN NUMBER);

TBD

INSTANCE_CALLOUT_IMP

Undocumented dbms_xdbutil_int.instance_callout_imp( obj_name IN VARCHAR2 obj_schema IN VARCHAR2 obj_type IN NUMBER prepost IN BINARY_INTEGER action OUT VARCHAR2 alt_name OUT VARCHAR2);

TBD

INSTANCE_EXPORT_ACTION

Undocumented dbms_xdbutil_int.instance_export_action( obj_name IN VARCHAR2 obj_schema IN VARCHAR2 obj_type IN NUMBER prepost IN BINARY_INTEGER action OUT VARCHAR2 alt_name OUT VARCHAR2

TBD

ISOBJECTGENERATED

Undocumented: Presumably returns 1 for a generated object, otherwise 0 dbms_xdbutil_int.isObjectGenerated( objname IN VARCHAR2, schname IN VARCHAR2) RETURN NUMBER;

SELECT dbms_xdbutil_int.isobjectgenerated('XDB', 'SYS_LOB0000042280C00022$$');

      

      DBMS_XDBUTIL_INT.ISOBJECTGENERATED('XDB','SYS_LOB0000042280C00022$$')

      ---------------------------------------------------------------------

                                                                          0

ISTABLEOUTOFLINE

Undocumented: Presumably returns 1 for an out of line table, otherwise 0 dbms_xdbutil_int.isTableOutOfLine( tablename IN VARCHAR2, owner IN VARCHAR2) RETURN NUMBER;

SELECT dbms_xdbutil_int.isTableOutOfLine('XDB$PATH_INDEX_PARAMS', 'XDB');

      

      DBMS_XDBUTIL_INT.ISTABLEOUTOFLINE('XDB$PATH_INDEX_PARAMS','XDB')

      ----------------------------------------------------------------

                                                                     0

ISXMLNESTEDTABLE

Undocumented: Presumably returns 1 if a nested table, otherwise 0 dbms_xdbutil_int.isXMLNestedTable( tablename IN VARCHAR2, schname IN VARCHAR2) RETURN NUMBER;

SELECT dbms_xdbutil_int.isXMLNestedTable('XDB$SCHEMA', 'XDB');

      

      DBMS_XDBUTIL_INT.ISXMLNESTEDTABLE('XDB$SCHEMA','XDB')

      -----------------------------------------------------

                                                          0

LOOKUPSCHEMAOID

Undocumented dbms_xdbutil_int.lookupSchemaOID(schemaoid IN RAW) RETURN VARCHAR2;

TBD

LOOKUPSCHEMAURL

Undocumented dbms_xdbutil_int.lookupSchemaURL(schemaurl IN VARCHAR2) RETURN RAW;

TBD

MIGRATEALLXMLFROM9201

Undocumented dbms_xdbutil_int.migrateAllXMLFrom9201;

exec dbms_xdbutil_int.migrateAllXMLFrom9201;

NUMTOHEX

Converts a number to hex dbms_xdbutil_int.numToHex(n IN NUMBER) RETURN RAW;

SELECT dbms_xdbutil_int.numToHex(42);

      

      DBMS_XDBUTIL_INT.NUMTOHEX(42)

      -----------------------------

      2A

      

      SELECT dbms_xdbutil_int.numToHex(43);

      

      DBMS_XDBUTIL_INT.NUMTOHEX(43)

      -----------------------------

      2B

      

      SELECT dbms_xdbutil_int.numToHex(47);

      

      DBMS_XDBUTIL_INT.NUMTOHEX(47)

      -----------------------------

      2F

      

      SELECT dbms_xdbutil_int.numToHex(420128);

      

      DBMS_XDBUTIL_INT.NUMTOHEX(420128)

      ---------------------------------

      066920

NUMTOHEX2

Converts a number to hex

Specifically what is different from this function, when compared to the above function, is not apparent. dbms_xdbutil_int.numToHex2(n IN NUMBER) RETURN RAW;

SELECT dbms_xdbutil_int.numToHex(420128);

      

      DBMS_XDBUTIL_INT.NUMTOHEX(420128)

      ---------------------------------

      066920

PATCHREPOSITORYRESCONFIGLIST

Undocumented dbms_xdbutil_int.patchRepositoryResConfigList;

dbms_xdbutil_int.patchRepositoryResConfigList;

      *

      ERROR at line 1:

      ORA-06502: PL/SQL: numeric or value error

RAWTONUM

Converts RAW to NUMBER dbms_xdbutil_int.rawToNum(prefix_code IN RAW) RETURN NUMBER;

SELECT utl_raw.cast_to_raw('ABC');

      

      UTL_RAW.CAST_TO_RAW('ABC')

      --------------------------

      414243

      

      SELECT dbms_xdbutil_int.rawToNum(utl_raw.cast_to_raw('ABC'));

      

      
      DBMS_XDBUTIL_INT.RAWTONUM(UTL_RAW.CAST_TO_RAW('ABC'))

      -----------------------------------------------------

                                                    4276803

      

      SELECT dbms_xdbutil_int.rawToNum('414243');

      

      DBMS_XDBUTIL_INT.RAWTONUM('414243')

      -----------------------------------

                                  4276803

RAWTONUM2

Converts RAW to NUMBER dbms_xdbutil_int.rawToNum2(prefix_code IN RAW) RETURN NUMBER;

SELECT dbms_xdbutil_int.rawToNum2(utl_raw.cast_to_raw('ABC'));

      

      DBMS_XDBUTIL_INT.RAWTONUM2(UTL_RAW.CAST_TO_RAW('ABC'))

      ------------------------------------------------------

                                                     4276803

SETLINKPARENTS

Undocumented dbms_xdbutil_int.setLinkParents;

exec dbms_xdbutil_int.setLinkParents;

SETLINKPARENTSNEW

Undocumented dbms_xdbutil_int.setLinkParentsNew;

exec dbms_xdbutil_int.setLinkParentsNew;

      

      PL/SQL procedure successfully completed.

SYSTEM_INFO_EXP

Undocumented dbms_xdbutil_int.system_info_exp( prePost IN BINARY_INTEGER, connectString OUT VARCHAR2, version IN VARCHAR2, new_block OUT BINARY_INTEGER); RETURN VARCHAR2;

TBD

USESETLINKPARENTSNEW

Undocumented dbms_xdbutil_int.useSetLinkParentsNew RETURN BOOLEAN;

BEGIN

        IF dbms_xdbutil_int.useSetLinkParentsNew THEN

          dbms_output.put_line('Using ParentsNew');

        ELSE

          dbms_output.put_line('Not Using ParentsNew');

        END IF;

      END;

      /

      Not Using ParentsNew

      

      PL/SQL procedure successfully completed.

XMLSCHEMADEPENDENCYLEVEL

Undocumented dbms_xdbutil_int.xmlSchemaDependencyLevel( schoid IN RAW, owner IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

XMLSCHEMAGETDEPENDENCYLIST

Undocumented dbms_xdbutil_int.XMLSchemaGetDependencyList( schoid IN RAW, owner IN VARCHAR2, depclob IN CLOB) RETURN BINARY_INTEGER;

TBD

XMLSCHEMASTRIPUSERNAME

Undocumented dbms_xdbutil_int.XMLSchemaStripUsername( schemadoc IN XMLTYPE, username IN VARCHAR2) RETURN CLOB;

conn xdb/xdb

      

      set long 1000000

      set pagesize 0

      set linesize 131

      col xml_out format a130

      col xml_len format 999999

      

      SELECT XMLTYPE(s.getclobval()) as xml_out

      FROM xdb$schema s

      WHERE rownum = 1;

      

      SELECT MIN(rowid) FROM xdb$schema;

      

      SELECT XMLTYPE(s.getclobval()) as xml_out

      FROM xdb$schema s

      WHERE rowid = 'AAANXLAACAAADecAAA';

      

      SELECT LENGTH(XMLTYPE(s.getclobval())) as xml_len

      FROM xdb$schema s

      WHERE rowid = 'AAANXLAACAAADecAAA';

      

      SELECT xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()), 'XDB') xml_out

      FROM xdb$schema s

      WHERE rowid = 'AAANXLAACAAADecAAA';

      

      col xml_out format 999999

      

      SELECT LENGTH(xdb.dbms_xdbutil_int.XMLSchemaStripUsername(XMLTYPE(s.getClobVal()), 'XDB')) xml_len

      FROM xdb$schema s

      WHERE rowid = 'AAANXLAACAAADecAAA';