Oracle DBMS_CSX_INT
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Internal support package with subroutines for DBMS_CSX_ADMIN when transporting a tablespace containing binary XML data.
AUTHID CURRENT_USER
Dependencies
ALL_XML_SCHEMAS DBA_XML_SCHEMA_DEPENDENCY DBMS_XSLPROCESSOR
ALL_XML_SCHEMA_ATTRIBUTES DBA_XML_SCHEMA_IMPORTS KU$_EXP_XMLSCHEMA_VIEW
ALL_XML_SCHEMA_COMPLEX_TYPES DBA_XML_SCHEMA_INCLUDES KU$_JOBSTATUS1220
ALL_XML_SCHEMA_ELEMENTS DBMS_ASSERT KU$_STATUS
ALL_XML_SCHEMA_NAMESPACES DBMS_CSX_ADMIN KU$_TABLE_XMLSCHEMA_VIEW
ALL_XML_SCHEMA_SIMPLE_TYPES DBMS_DATAPUMP KU$_TTS_TYPES_VIEW
ALL_XML_SCHEMA_SUBSTGRP_HEAD DBMS_LOB KU$_XMLSCHEMA_TYPES_VIEW
ALL_XML_SCHEMA_SUBSTGRP_MBRS DBMS_STANDARD KU$_XMLSCHEMA_VIEW
DBA_XMLSCHEMA_LEVEL_VIEW DBMS_XDBUTIL_INT USER_XML_SCHEMAS
DBA_XMLSCHEMA_LEVEL_VIEW_DUP DBMS_XDB_LIB XDB$SCHEMA
DBA_XML_SCHEMAS DBMS_XMLDOM XMLTYPE
Documented No
First Available 11.1.0.6
Security Model Owned by XDB with EXECUTE granted to PUBLIC
Source $ORACLE_HOME/rdbms/admin/prvtxdb0.plb
Subprograms
 
CreateTokenTables
Undocumented dbms_csx_int.createTokenTables(guid IN RAW);
See GetNewTokenSetIDs Demo Below
 
genTTMapping (new 18c)
Undocumented dbms_csx_int.genTTMapping(
guid     IN RAW,
toksuf   IN VARCHAR2,
name     IN VARCHAR2,
schema   IN VARCHAR2,
qn       IN VARCHAR2,
nm       IN VARCHAR2,
pt       IN VARCHAR2,
seqowner IN VARCHAR2,
seqname  IN VARCHAR2,
seqstart IN NUMBER);
TBD
 
GetCompiledSchema
Undocumented dbms_csx_int.getCompiledSchema(schemaURL IN VARCHAR2)
RETURN XMLTYPE;
TBD
 
GetCompiledSchemaByID
Undocumented dbms_csx_int.getCompiledSchemaByID(schemaOID IN VARCHAR2)
RETURN XMLTYPE;
TBD
 
GetCSXSchema
Undocumented dbms_csx_int.getCSXSchema(schemaDoc IN XMLTYPE) RETURN XMLTYPE;
TBD
 
GetNewTokenSetIDs (new 18c)
Undocumented dbms_csx_int.GetNewTokenSetIDs(
ewguid   OUT RAW,
guidhash OUT VARCHAR2);
DECLARE
 ewg   RAW(64);
 ghash VARCHAR2(64);
BEGIN
  dbms_csx_int.GetNewTokenSetIDs(ewg, ghash);
  dbms_output.put_line(ewg);
  dbms_output.put_line(ghash);

  dbms_csx_int.createTokenTables(ewg);
END;
/
7916F4C3D20A43C093C66F9C0CE3809D
3P2SRC7KGA8F097HJFJG6E704U
 
GetVocabulary
Undocumented dbms_csx_int.getVocabulary(
vocaId   IN BINARY_INTEGER,
vocabType IN BINARY_INTEGER,
rGUID      IN RAW)
RETURN XMLTYPE;
TBD
 
GetVocabularyFromToken
Undocumented dbms_csx_int.getVocabularyFromToken(
token     IN VARCHAR2,
isAttr    IN BINARY_INTEGER,
nmSpcID   IN BINARY_INTEGER,
tokenType IN BINARY_INTEGER,
rGUID     IN RAW)
RETURN XMLTYPE;
TBD
 
GetVocabularyFromTokenNoTxn
Undocumented dbms_csx_int.getVocabularyFromTokenNoTxn(
isGen     OUT BINARY_INTEGER,
token     IN  VARCHAR2,
isAttr    IN  BINARY_INTEGER,
nmSpcID   IN  BINARY_INTEGER,
tokenType IN  BINARY_INTEGER,
rGUID     IN  RAW,
toCreate  IN  BINARY_INTEGER)
RETURN XMLTYPE;
TBD
 
GetVocabularyNoTxn
Undocumented dbms_csx_int.getVocabularyNoTxn(
vocabID   IN BINARY_INTEGER,
vocabType IN BINARY_INTEGER,
rGUID     IN RAW)
RETURN XMLTYPE;
TBD
 
GuidFrom32
Undocumented dbms_csx_int.guidFrom32(guid32 IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_csx_int.guidFrom32('Morgan')
FROM dual;
 
GuidTo32
Undocumented dbms_csx_int.guidTo32(guidhex IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_csx_int.guidTo32(SYS_GUID())
FROM dual;
 
ImportMergeTokenTables
Undocumented dbms_csx_int.importMergeTokenTables;
exec dbms_csx_importMergeTokenTables;
 
LockTokenManager
Undocumented dbms_csx_int.lockTokenManager(rGUID IN RAW);
TBD
 
MergeImportedTokens
Undocumented dbms_csx_int.mergeImportedTokens;
exec dbms_csx_int.mergeImportedTokens;
 
PopulateKDSOFromGUID
Undocumented dbms_csx_int.populateKDSOFromGUID(guid IN RAW, toksuf IN VARCHAR2);
TBD
 
PopulateTokenTableSet
Undocumented dbms_csx_int.PopulateTokenTableSet(data IN XMLTYPE, eguid IN RAW);
TBD
 
Reencode_Binary_to_Central (new 18c)
Undocumented dbms_csx_int.Reencode_Binary_to_Central(callmode IN NUMBER);
TBD
 
RegisterToken
Undocumented

Overload 1
dbms_csx_int.registerToken(
tab     IN VARCHAR2,
nmSpcId IN NUMBER,
local   IN VARCHAR2,
flags   IN NUMBER,
id      IN NUMBER);
TBD
Overload 2 dbms_csx_int.RegisterToken(
tab      IN VARCHAR2,
nmSpcUri IN VARCHAR2,
id       IN NUMBER);
TBD
 
ToValidate
Undocumented dbms_csx_int.toValidate(test IN VARCHAR2)
RETURN BINARY_INTEGER;
SELECT dbms_csx_int.ToValidate('Morgan')
FROM dual;
 
TTMappingGenerator (new 18c)
Undocumented dbms_csx_int.TTMappingGenerator(
guid     IN RAW,
tokSuf   IN VARCHAR2,
name     IN VARCHAR2,
schema   IN VARCHAR2,
qn       IN VARCHAR2,
nm       IN VARCHAR2,
pt       IN VARCHAR2,
seqOwner IN VARCHAR2,
seqName  IN VARCHAR2,
seqStart IN NUMBER);
TBD
 
UpdateMasterTable
Undocumented dbms_csx_admin.updateMasterTable(
name   IN VARCHAR2,
schema IN VARCHAR2,
level  IN NUMBER,
guid   IN RAW,
tokSuf IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
DataPump Executable
DBMS_CSX_ADMIN
DBMS_CSX_INT2
DBMS_DATAPUMP
DBMS_EXTENDED_TTS_CHECKS
DBMS_PLUGTS
DBMS_PLUGTSP
DBMS_TDB
DBMS_TTS
What's New In 12cR2
What's New In 18cR3

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