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
- 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:
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.