E Oracle Clinical Tablespaces

This appendix lists the tablespaces in an Oracle Clinical database and their use. Names preceded by "d-" are created when the database is created. The rest are created when the Installer is run to install Oracle Clinical in the database.

DISC_REP_DATA: Disconnected Replication tables
RBS: Rollback segments
RXA_DES_DATA: Design tables
RXA_DES_IDX: Indexes for Design tables
RXA_LR_DATA: Lab Ranges tables
RXA_LR_IDX: Indexes for Lab Ranges tables
RXC_APP_IDX_TSPA: Indexes for Application Definition tables
RXC_APP_TSPA: Application Definition tables
RXC_DCD_IDX_TSPA: Indexes for Data Collection Definition tables
RXC_DCD_TSPA: Data Collection Definition tables
RXC_DCMQ_IDX_TSPA: Indexes for Data Management tables
RXC_DCMQ_TSPA: Data Management tables
RXC_DEF_IDX_TSPA: Indexes for Definition tables
RXC_DEF_TSPA: Definition tables
RXC_DISC_IDX_TSPA: Indexes for Discrepancy Management tables
RXC_DISC_TSPA: Discrepancy Management tables
RXC_GLIB_IDX_TSPA: Indexes for Global Library tables
RXC_GLIB_TSPA: Global Library tables
RXC_LI_IDX_TSPA: Indexes for Log-In tables
RXC_LI_TSPA: Log-In tables
RXC_RESP_IDX_TSPA: Indexes for Responses table
RXC_RESP_TSPA: Responses table
RXC_VRV_IDX_TSPA: Indexes for Validation Reported Values table
RXC_VRV_TSPA: Validation Reported Values table
d-SYSTEM: Standard Oracle tables
d-TEMP: Standard Oracle tables
TEMP1: Temporary Data Extract tables
TEST_DATA: Test tables
TEST_INDEX: Indexes for Test tables
d-TOOLS: Standard Oracle tables
d-USERS: Standard Oracle tables

In addition, the Oracle Thesaurus Management System creates these tablespaces:

TMS_DATA: Data tables
TMS_IDX: Index tables