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