Which Oracle's schemas corresponds to JTS, CCM, QM, Content Store (RRDI) and DW
Hi,
We're using RTC/QM 4.0.2 and RRDI 2.0.1. Currently we have only 1 DB instance that contains the schemas for JTS, CCM, QM, RRDI (Content Store) and DW.
We're migrating to a schema where we'll have two Oracle's instances: one for JTS, CCM, QM and Content Store, and a new one that only contains the Data Warehouse.
I need to know which SCHEMAS and TABLESPACES correspond to which applications, so I can move the Data-Warehouse's schemas to the new DB instance. Following are the lists of schemas that we have in our Oracle DB:
It is clear which are the schemas used by JTS (JTS), QM (QM), and CCM (TEAMCONCERT). However it is not clear for me which are used by the Content Store and which ones for DW.
I´ll appreciate your help!
We're using RTC/QM 4.0.2 and RRDI 2.0.1. Currently we have only 1 DB instance that contains the schemas for JTS, CCM, QM, RRDI (Content Store) and DW.
We're migrating to a schema where we'll have two Oracle's instances: one for JTS, CCM, QM and Content Store, and a new one that only contains the Data Warehouse.
I need to know which SCHEMAS and TABLESPACES correspond to which applications, so I can move the Data-Warehouse's schemas to the new DB instance. Following are the lists of schemas that we have in our Oracle DB:
| TEAMCONCERT_RID |
| TEAMCONCERT |
| JTS |
| QM |
| RICALM |
| RISCHK |
| RIASSET |
| RIDW |
| RIODS |
| CONFIG |
| RPTUSER |
| OTM |
| OLT |
| OATS |
It is clear which are the schemas used by JTS (JTS), QM (QM), and CCM (TEAMCONCERT). However it is not clear for me which are used by the Content Store and which ones for DW.
I´ll appreciate your help!
4 answers
jts uses jts schema
qm uses qm schema
DataWarehouse uses the following schemas
CONFIG
RIODS
RIDW
RIASSET
RISCHK
RICALM
For ccm it usually uses the ccm schema. however if during the setup a different name was used such as "TEAMCONCERT ", this would need to be verified by reviewing the ccm configuration. Go to ccm admin page -> servers -> configuration -. Databases As a sanity check i would do the same for the jts and qm application to verify the schema names.
WIl need to depend on someone mor familiar with RRDI to verify which schemas it uses.
qm uses qm schema
DataWarehouse uses the following schemas
CONFIG
RIODS
RIDW
RIASSET
RISCHK
RICALM
For ccm it usually uses the ccm schema. however if during the setup a different name was used such as "TEAMCONCERT ", this would need to be verified by reviewing the ccm configuration. Go to ccm admin page -> servers -> configuration -. Databases As a sanity check i would do the same for the jts and qm application to verify the schema names.
WIl need to depend on someone mor familiar with RRDI to verify which schemas it uses.