Content Platform Engine, Version 5.2.1 Database: Oracle

Creating Oracle table spaces for a Content Platform Engine object store

Create Oracle table spaces for a Content Platform Engine object store.

About this task

Use your database tools to create table spaces for an object store. Do not share the database user for the GCD with the object store database user.

Start of change If you want to add a workflow system to an object store that does not already have one, the workflow system can use the table spaces that are used by the object store. Alternatively, you can create new table spaces for the workflow system, according to the rules on table space types and minimum sizes that are documented here. End of change

Procedure

Create a user (cpe_db_user), password, and default table space in the Oracle database for an object store that Content Platform Engine will access. See Creating Content Platform Engine database accounts for information about the user and required permissions.

Create the required and any optional table spaces for a Content Platform Engine object store. Note that the index and LOB table spaces are optional.

Table space names used by Content Platform Engine must contain only alphanumeric and underscore characters. Names must start with an alphabetic character and must be at most 30 characters long.

For performance reasons, specify locally managed, instead of dictionary managed, table spaces. (The table spaces you create via Oracle Enterprise Manager are locally managed by default.)

The following table shows the recommended table space names, types, and minimum sizes:

Table 1. Recommended table space names, types, and minimum sizes
Table space Name	Table space Type	Minimum Size (MB)	Description
`data_ts`	Permanent	400	This is the default name of the data table space used by Content Platform Engine. Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter drop-down arrow in Column F, Property or Parameter (in user interface), to select Data table space name.
`index_ts` (optional)	Permanent	300	This is the default name of the optional default index table space used by Content Platform Engine. If you do not create an index table space, the data table space will be used for indexes. Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter drop-down arrow in Column F, Property or Parameter (in user interface), to select Index table space name.
`lob_ts` (optional)	Permanent	300	This is the default name of the optional default LOB table space used by Content Platform Engine. If you do not create a LOB table space, the data table space will be used for LOB data. Record this value in your customized Installation and Upgrade Worksheet. To find this property, use the Autofilter drop-down arrow in Column F, Property or Parameter (in user interface), to select LOB table space name.
`temp_ts`	Temporary	2 GB	This is the default temporary table space, required for Content Platform Engine use.

Record the values for the Database user name, the Database password, and the table space names in your customized Installation and Upgrade Worksheet. To find these properties, set the Autofilter for Column E Installation or Configuration Program for CM: Configure Object Store JDBC Data Sources (object store 1). Then set the Autofilter for Column D ISV Component Vendor to "Oracle ". If your customized worksheet shows more than one object store, create and provide values for all of them.