Commerce Service Center requires two different database user accounts for database configuration. Create the following accounts before configuring the database:

Database Schema

Contents

svcagent
(Agent)

Versioned repository tables. Referred to in this document as the agent schema. This schema is accessed from the agent-facing servers.

svcadmin (Production)

Unversioned repository tables. Referred to in this document as the production schema. This schema is accessed from the customer-facing servers.

Databases can be configured with their tables on separate machines, separate table spaces or partitions, or in other configurations.

The following table outlines the template files used by the CIM installation process, the SQL files that are called from that template, and the schema to which the SQL files will be pointed:

Template

SQL Files

Schema

production-ddl-template

DCS-CSR_ddl.sql,
DCS-CSR_ticketing_ddl.sql
unversioned_DCS-CSR_site_ddl.sql

Production

agent-ddl-template

DCS-CSR_logging_ddl.sql,
DCS-CSR_profile_ddl.sql
,
DCS-CSR_approvals_ddl.sql

Agent

management-ddl-template

versioned_DCS-CSR_site_ddl.sql

Management


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices