IX Schema

This section lists the names of the scripts that create the information exchange (IX) schema group and describes the objects in the schemas. Table 4-4 lists the IX scripts in alphabetical order.

Table 4-4 Information Exchange (IX) Schema Scripts

Script Name	Description
`cix_v3.sql`	Creates the `IX` schema objects.
`dix_v3.sql`	Drops the `IX` schema objects.
`ix_main.sql`	Main script for the `IX` schema; calls other scripts.
`vix_v3.sql`	Enqueues, dequeues, and verifies `IX` objects.

List of IX Objects

EVALUATION CONTEXT 
 AQ$_ORDERS_QUEUETABLE_V 
 AQ$_STREAMS_QUEUE_TABLE_V 
 
INDEX 
 SYS_C003540 
 SYS_C003543 
 SYS_C003548 
 SYS_C003551 
 SYS_IOT_TOP_45932 
 SYS_IOT_TOP_45934 
 SYS_IOT_TOP_45936 
 SYS_IOT_TOP_45939 
 SYS_IOT_TOP_45949 
 SYS_IOT_TOP_45951 
 SYS_IOT_TOP_45953 
 SYS_IOT_TOP_45956 
 
LOB 
 SYS_LOB0000045926C00036$$ 
 SYS_LOB0000045941C00028$$ 
 SYS_LOB0000045941C00029$$ 
 
QUEUE 
 AQ$_ORDERS_QUEUETABLE_E 
 AQ$_STREAMS_QUEUE_TABLE_E 
 ORDERS_QUEUE 
 STREAMS_QUEUE 
 
RULE SET 
 ORDERS_QUEUE_N 
 ORDERS_QUEUE_R 
 STREAMS_QUEUE_N 
 STREAMS_QUEUE_R 
 
SEQUENCE 
 AQ$_ORDERS_QUEUETABLE_N 
 AQ$_STREAMS_QUEUE_TABLE_N 
 
TABLE 
 AQ$_ORDERS_QUEUETABLE_G 
 AQ$_ORDERS_QUEUETABLE_H 
 AQ$_ORDERS_QUEUETABLE_I 
 AQ$_ORDERS_QUEUETABLE_S 
 AQ$_ORDERS_QUEUETABLE_T 
 AQ$_STREAMS_QUEUE_TABLE_G 
 AQ$_STREAMS_QUEUE_TABLE_H 
 AQ$_STREAMS_QUEUE_TABLE_I 
 AQ$_STREAMS_QUEUE_TABLE_S 
 AQ$_STREAMS_QUEUE_TABLE_T 
 ORDERS_QUEUETABLE 
 STREAMS_QUEUE_TABLE 
 SYS_IOT_OVER_45936 
 SYS_IOT_OVER_45953 
 
TYPE 
 ORDER_EVENT_TYP 
 
VIEW 
 AQ$ORDERS_QUEUETABLE 
 AQ$ORDERS_QUEUETABLE_R 
 AQ$ORDERS_QUEUETABLE_S 
 AQ$STREAMS_QUEUE_TABLE 
 AQ$STREAMS_QUEUE_TABLE_R 
 AQ$STREAMS_QUEUE_TABLE_S

IX Table Descriptions

Table AQ$_ORDERS_QUEUETABLE_G
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 MSGID                                     NOT NULL RAW(16)
 SUBSCRIBER#                               NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(30)
 ADDRESS#                                  NOT NULL NUMBER
 SIGN                                               SYS.AQ$_SIG_PROP
 DBS_SIGN                                           SYS.AQ$_SIG_PROP
 
Table AQ$_ORDERS_QUEUETABLE_H
 Name                                Null?    Type
 ------------------------------------ -------- ----------------------------
 MSGID                                NOT NULL RAW(16)
 SUBSCRIBER#                          NOT NULL NUMBER
 NAME                                 NOT NULL VARCHAR2(30)
 ADDRESS#                             NOT NULL NUMBER
 DEQUEUE_TIME                                  TIMESTAMP(6) WITH LOCAL TIME ZONE
 TRANSACTION_ID                                VARCHAR2(30)
 DEQUEUE_USER                                  VARCHAR2(30)
 PROPAGATED_MSGID                              RAW(16)
 RETRY_COUNT                                   NUMBER
 HINT                                          ROWID
 SPARE                                         RAW(16)
 
Table AQ$_ORDERS_QUEUETABLE_I
 Name                                 Null?    Type
 ------------------------------------ -------- ----------------------------
 SUBSCRIBER#                          NOT NULL NUMBER
 NAME                                 NOT NULL VARCHAR2(30)
 QUEUE#                               NOT NULL NUMBER
 MSG_ENQ_TIME                         NOT NULL TIMESTAMP(6) WITH LOCAL TIME ZONE
 MSG_STEP_NO                          NOT NULL NUMBER
 MSG_CHAIN_NO                         NOT NULL NUMBER
 MSG_LOCAL_ORDER_NO                   NOT NULL NUMBER
 MSGID NOT NULL                                RAW(16)
 HINT                                          ROWID
 SPARE                                         RAW(16)
 
Table AQ$_ORDERS_QUEUETABLE_S 
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SUBSCRIBER_ID                             NOT NULL NUMBER
 QUEUE_NAME                                NOT NULL VARCHAR2(30)
 NAME                                               VARCHAR2(30)
 ADDRESS                                            VARCHAR2(1024)
 PROTOCOL                                           NUMBER
 SUBSCRIBER_TYPE                                    NUMBER
 RULE_NAME                                          VARCHAR2(30)
 TRANS_NAME                                         VARCHAR2(61)
 RULESET_NAME                                       VARCHAR2(65)
 NEGATIVE_RULESET_NAME                              VARCHAR2(65)
 
Table AQ$_ORDERS_QUEUETABLE_T
 Name                                 Null?    Type
 ------------------------------------ -------- ----------------------------
 NEXT_DATE                            NOT NULL TIMESTAMP(6) WITH LOCAL TIME ZONE
 TXN_ID NOT NULL                               VARCHAR2(30)
 MSGID NOT NULL                                RAW(16)
 ACTION                                        NUMBER
 
Table AQ$_STREAMS_QUEUE_TABLE_G
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 MSGID                                     NOT NULL RAW(16)
 SUBSCRIBER#                               NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(30)
 ADDRESS#                                  NOT NULL NUMBER
 SIGN                                               SYS.AQ$_SIG_PROP
 DBS_SIGN                                           SYS.AQ$_SIG_PROP
 
Table AQ$_STREAMS_QUEUE_TABLE_H
 Name                                 Null?    Type
 ------------------------------------ -------- ----------------------------
 MSGID                                NOT NULL RAW(16)
 SUBSCRIBER#                          NOT NULL NUMBER
 NAME                                 NOT NULL VARCHAR2(30)
 ADDRESS#                             NOT NULL NUMBER
 DEQUEUE_TIME                                  TIMESTAMP(6) WITH LOCAL TIME ZONE
 TRANSACTION_ID                                VARCHAR2(30)
 DEQUEUE_USER                                  VARCHAR2(30)
 PROPAGATED_MSGID                              RAW(16)
 RETRY_COUNT                                   NUMBER
 HINT                                          ROWID
 SPARE                                              RAW(16)
 
Table AQ$_STREAMS_QUEUE_TABLE_I
 Name                                 Null?    Type
 ------------------------------------ -------- ----------------------------
 SUBSCRIBER#                          NOT NULL NUMBER
 NAME                                 NOT NULL VARCHAR2(30)
 QUEUE#                               NOT NULL NUMBER
 MSG_ENQ_TID                          NOT NULL VARCHAR2(30)
 SENDER#                              NOT NULL NUMBER
 TXN_STEP#                            NOT NULL NUMBER
 MSG_ENQ_TIME                         NOT NULL TIMESTAMP(6) WITH LOCAL TIME ZONE
 MSG_STEP_NO                          NOT NULL NUMBER
 MSG_CHAIN_NO                         NOT NULL NUMBER
 MSG_LOCAL_ORDER_NO                   NOT NULL NUMBER
 MSGID                                NOT NULL RAW(16)
 HINT                                 ROWID
 SPARE                                RAW(16)
 
Table AQ$_STREAMS_QUEUE_TABLE_S
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SUBSCRIBER_ID                             NOT NULL NUMBER
 QUEUE_NAME                                NOT NULL VARCHAR2(30)
 NAME                                               VARCHAR2(30)
 ADDRESS                                            VARCHAR2(1024)
 PROTOCOL                                           NUMBER
 SUBSCRIBER_TYPE                                    NUMBER
 RULE_NAME                                          VARCHAR2(30)
 TRANS_NAME                                         VARCHAR2(61)
 RULESET_NAME                                       VARCHAR2(65)
 NEGATIVE_RULESET_NAME                              VARCHAR2(65)
 
Table AQ$_STREAMS_QUEUE_TABLE_T
 Name                                 Null?    Type
 ------------------------------------ -------- ----------------------------
 NEXT_DATE                            NOT NULL TIMESTAMP(6) WITH LOCAL TIME ZONE
 TXN_ID                               NOT NULL VARCHAR2(30)
 MSGID                                NOT NULL RAW(16)
 ACTION                               NUMBER
 
Table ORDERS_QUEUETABLE
 Name                                 Null?    Type
 ------------------------------------ -------- ----------------------------
 Q_NAME                                        VARCHAR2(30)
 MSGID                                NOT NULL RAW(16)
 CORRID                                        VARCHAR2(128)
 PRIORITY                                      NUMBER
 STATE                                         NUMBER
 DELAY                                         TIMESTAMP(6) WITH LOCAL TIME ZONE
 EXPIRATION                                    NUMBER
 TIME_MANAGER_INFO                             TIMESTAMP(6) WITH LOCAL TIME ZONE
 LOCAL_ORDER_NO                                NUMBER
 CHAIN_NO                                      NUMBER
 CSCN                                          NUMBER
 DSCN                                          NUMBER
 ENQ_TIME                                      TIMESTAMP(6) WITH LOCAL TIME ZONE
 ENQ_UID                                       VARCHAR2(30)
 ENQ_TID                                       VARCHAR2(30)
 DEQ_TIME                                      TIMESTAMP(6) WITH LOCAL TIME ZONE
 DEQ_UID                                       VARCHAR2(30)
 DEQ_TID                                       VARCHAR2(30)
 RETRY_COUNT                                   NUMBER
 EXCEPTION_QSCHEMA                             VARCHAR2(30)
 EXCEPTION_QUEUE                               VARCHAR2(30)
 STEP_NO                                       NUMBER
 RECIPIENT_KEY                                 NUMBER
 DEQUEUE_MSGID                                 RAW(16)
 SENDER_NAME                                   VARCHAR2(30)
 SENDER_ADDRESS                                VARCHAR2(1024)
 SENDER_PROTOCOL                               NUMBER
 USER_DATA                                     ORDER_EVENT_TYP
 USER_PROP                                     SYS.ANYDATA
 
Table STREAMS_QUEUE_TABLE
 Name                                 Null?    Type
 ------------------------------------ -------- ----------------------------
 Q_NAME                                        VARCHAR2(30)
 MSGID                                NOT NULL RAW(16)
 CORRID                                        VARCHAR2(128)
 PRIORITY                                      NUMBER
 STATE                                         NUMBER
 DELAY                                         TIMESTAMP(6) WITH LOCAL TIME ZONE
 EXPIRATION                                    NUMBER
 TIME_MANAGER_INFO                             TIMESTAMP(6) WITH LOCAL TIME ZONE
 LOCAL_ORDER_NO                                NUMBER
 CHAIN_NO                                      NUMBER
 CSCN                                          NUMBER
 DSCN                                          NUMBER
 ENQ_TIME                                      TIMESTAMP(6) WITH LOCAL TIME ZONE
 ENQ_UID                                       VARCHAR2(30)
 ENQ_TID                                       VARCHAR2(30)
 DEQ_TIME                                      TIMESTAMP(6) WITH LOCAL TIME ZONE
 DEQ_UID                                       VARCHAR2(30)
 DEQ_TID                                       VARCHAR2(30)
 RETRY_COUNT                                   NUMBER
 EXCEPTION_QSCHEMA                             VARCHAR2(30)
 EXCEPTION_QUEUE                               VARCHAR2(30)
 STEP_NO                                       NUMBER
 RECIPIENT_KEY                                 NUMBER
 DEQUEUE_MSGID                                 RAW(16)
 SENDER_NAME                                   VARCHAR2(30)
 SENDER_ADDRESS                                VARCHAR2(1024)
 SENDER_PROTOCOL                               NUMBER
 USER_PROP                                     SYS.ANYDATA
 USER_DATA                                     SYS.ANYDATA