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.
-
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