Manually Running the SQL Script File

After Generate Triggers finishes, if the EXEC parameter is FALSE, then you must run the SQL script file.

To manually run the SQL script file

1. Connect to the server that contains the database.

   Connect as the Siebel table owner (Oracle/DB2) or database owner (MSSQL). Use the SQL tool that your RDBMS vendor provides.

   For example, use SQL*Plus for Oracle or the Microsoft SQL Server Studio for MSSQL.

2. Run the SQL script file that the Trigger File Name parameter references.

   The default file name is trigger.sql. The default location of this file is the root directory of where you installed the Siebel Server. For example:

   ...\ses\siebsrvr\trigger.sql

   If your environment uses an MS SQL server database, then you must run the trigger.sql script as the owner login, which is also known as the dbo login.

3. After executing the trigger.sql script, ensure that there are no errors thrown. If so, examine the logs and determine the source of the issue and correct the policies as necessary. If the source of the issue is unclear, log a Service Request with Oracle Support.