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.

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

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.

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:

Scripts for creating Contact Optimization system tables
Data source type	Script name
IBM® 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.