Oracle | DBMS_CSX

Oracle DBMS_CSX_INT2 Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented but appears related to Transportable Tablespaces for tablespaces containing binary XML data.

AUTHID DEFINER

Dependencies

DBMS_XDB_LIB

Documented No

First Available 12.2

Security Model Owned by XDB with EXECUTE granted to PUBLIC

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

Subprograms

GETDEFAULTGUID

GETTABLEGUID

GETDEFAULTGUID

Returns a GUID for transportable tablespaces dbms_csx_int2.getDefaultGUID RETURN RAW;

SQL> SELECT dbms_csx_int2.getDefaultGUID

        2  FROM dual;

      

      GETDEFAULTGUID

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

      4700D2108ACA557EE05387E5E50A8899

GETTABLEGUID

Returns a GUID for a named table ... at least in theory as the example at right returns NULL dbms_csx_int2.getTableGUID( owner_in IN VARCHAR2, table_name_in IN VARCHAR2) RETURN RAW;

SELECT dbms_csx_int2.getTableGUID('SCOTT', 'EMP')

      FROM dual;