Create the database and tablespaces

After installing the Oracle software, create the database and tablespaces. The Oracle Central Coding application uses the Coding application and Coding platform tablespaces listed in the following table.

  • Note the names of the tablespaces you create.

    You need the names when you enter values for the database users during the Oracle Central Coding software installation.

    Each tablespace has one or more associated database users, which the installation wizard creates when you install a Oracle Central Coding application server. For more information, see Installing a Oracle Central Coding application server.

    Note:

    For demonstration purposes in this guide, example names are provided for the recommended tablespaces, and for their associated database users and passwords. The same example name is used for both the user name and password.

    The Central Coding Database User name and the Coding Platform Database User name cannot be the same.

    The tablespace and user names are not case-sensitive. The passwords are case‑sensitive.

  • The Oracle Central Coding application tablespace contains the coding dictionary database, which is created by the Dictionary Loader tool. For more information, see About the Dictionary Loader tool.

Note:

All entries used as Oracle database objects (such as user names, passwords, and tablespaces) should follow Oracle recommendations for naming conventions. In addition, Oracle recommends using strong passwords, as described in the Security Guide.
Tablespace Size Contains Database user(s)

Coding application

Example name: CODING

500 MB

Auto extend enabled,

10 MB increments.

Oracle Central Coding application

Oracle Central Coding Database User

Example name: cca

Coding platform

Example name: CCP

100 MB

Auto extend enabled,

10 MB increments.

Coding dictionaries

  • Coding Platform Database User

    Example name: codingplatform

  • Coding Dictionary Database User

    Example name: codingdictionaries