Database Guide › Oracle Guidelines › Database Configuration › Tablespaces for CA DataMinder

Tablespaces for CA DataMinder

Applicable to the CMS and gateways

When you install the CMS or manually create Oracle users for CA DataMinder, you need to specify a tablespace for each Oracle user. For the primary and search users, this can be an existing, shared tablespace. But if you specify a separate schema owner, we recommend that you assign this user its own separate tablespace. This has several advantages:

• It allows precise monitoring of the CMS database, since no other products are using the tablespace.
• It permits off-line maintenance of your CA DataMinder tablespace without disrupting other products or databases that may be sharing your Oracle server.

You will reference these tablespaces when you install the CMS and if you manually create Oracle users for CA DataMinder.