E Oracle Clinical Tablespaces

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

Name	Oracle Clinical Use
DISC_REP_DATA	Disconnected Replication tables
RBS	To hold 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:

Name	Oracle Thesaurus Management System Use
TMS_DATA	Data tables
TMS_IDX	Index tables