Regenerating the schema.ddl File

Use this procedure to regenerate the schema.ddl file.

To regenerate the schema.ddl file

1. On the Siebel Server where the Siebel Database Server files are installed, navigate to the following location:

   Windows: SIEBEL_ROOT\bin

   UNIX: $SIEBEL ROOT/bin

2. Run the following command:

   ddldict /u DatabaseOwner /p Password /c "ODBCDataSource" /d TableOwner 
   /f DBSRVR_ROOT\DatabasePlatform\schema.ddl /e y /a y /l SiebelLogDir\sch_dict.log 
   /n "Siebel Repository" /t dcir

   where:

   • DatabaseOwner is the Siebel database Administrator account name.

   • Password is the Siebel database Administrator account password.

   • ODBCDataSource is the ODBC name for connecting to the database. Enclose the name in quotes.

   • TableOwner is the Siebel table owner name.

   • DBSRVR_ROOT is the absolute path to the Siebel Database Configuration Utilities installation directory.

   • DatabasePlatform is the Siebel Database Configuration Utilities directory name for the database, that is, DB2390. The example shows Windows path syntax. On UNIX systems, use UNIX path syntax.

   • SiebelLogdir is the path to the directory where you want the output log placed (log output directory). The example shows Windows path syntax. On UNIX systems, use UNIX path syntax.

3. After the command completes, review the output logs for errors. If the log indicates there are errors, create a service request (SR) on My Oracle Support. You can log service requests by accessing My Oracle Support (Service Request tab), or by using your existing phone support numbers to contact Oracle Global Customer Support.