Create the database and tablespaces

After installing the Oracle software, create the database and tablespaces. The 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 Central Coding software installation.

Each tablespace has one or more associated database users, which the installation wizard creates when you install a Central Coding application server. For more information, see Installing a 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 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 Secure Configuration Guide.

Descriptions of Central Coding tablespaces

Tablespace	Size	Contains	Database user(s)
Coding application Example name: CODING	500 MB Auto extend enabled, 10 MB increments.	Central Coding application	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

Tablespace

Size

Contains

Database user(s)

Coding application

Example name: CODING

500 MB

Auto extend enabled,
10 MB increments.

Central Coding application

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