Creating an Oracle database

An SQL script file is included for each supported RDBMS in the Connections Engagement Center zip file. The SQL scripts can be found in the subdirectory SQLScripts.

Step Instructions
1

Edit the script and change the user for accessing the ICEC database in the following statement:

CREATE USER "XCC" PROFILE "DEFAULT" IDENTIFIED BY "Pa88w0rd" DEFAULT TABLESPACE "XCCTABSPACE" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;

2

Run the SQL Plus tool available from your Oracle installation:

image

3

Log into the system and run the following command:

@path_to_ICEC_install_files/Create_XCC_Oracle_Database.sql

image

Note: If you do not want to use the SQL script, make sure that the user "XCC" has the necessary access rights to the database.

Close the command window.