Creating and populating the Contact Optimization system tables manually

During installation, the Contact Optimization installer accesses the Campaign system tables to create the Contact Optimization system tables automatically. If the system tables are not created automatically, you must run the Contact Optimization SQL scripts against the appropriate database to create and populate the Contact Optimization system tables manually.

About this task

Complete the following steps to create and populate the Contact Optimization system tables manually:

Procedure

  1. To create and populate the Contact Optimization system tables, run the SQL scripts against the database or schema that holds the Campaign system tables.

    The SQL scripts are in the ddl directory under the Contact Optimization installation.

  2. If your Campaign system tables are configured for unicode, use the appropriate script in the ddl/unicode directory under the Contact Optimization installation.

    Use the information in the following table to run the appropriate script against the database to create the Contact Optimization system tables manually:

    Table 1. Scripts for creating Contact Optimization system tables

    A two-column table lists the data source type in the first column, and the script to use in the second column.

    Data source type Script name

    HCL® DB2®

    aco_systab_db2.sql

    Microsoft™ SQL Server

    aco_systab_sqlsvr.sql

    Oracle

    aco_systab_ora.sql

    There is only one script to populate the Contact Optimization tables, aco_populate_tables.sql. There is no unicode equivalent script for the aco_populate_tables.sql script that is used to populate the tables.