1. Database Upgrade Guide
  2. Regenerating the schema.ddl File

Regenerating the schema.ddl File

This task is a step in Process of Regenerating the Siebel Repository Definition Files. 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 quotation marks.

    • TableOwner is the Siebel table owner name.

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

    • DatabasePlatform is the Siebel Database Server directory name for the database, for example, Oracle. The example shows the Windows path syntax. On UNIX systems, use the UNIX path syntax.

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

  3. After the command completes, review the output log files for errors. If the log indicates there are errors, then create a service request (SR) on My Oracle Support, or contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle’s Application Expert Services.