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

Regenerating the schema.ddl File

Use this procedure to regenerate the schema*.ddl files.

Regenerate the schema*.ddl Files

  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: 

    genddl -u $UserName -p $Password -o "$ODBCDataSource" -t $TableOwner -r "Siebel Repository" -s $SiebelRoot 
-f $DbsrvrRoot/$DatabasePlatform -a "Customer"

    where:

    • $User is the Siebel Administrator user name
    • $Password for the Siebel Administrator user
    • ODBCDataSource is the ODBC name for the database. Enclose it in quotes.
    • $TableOwner is the Siebel Database tableowner name
    • $SiebelRoot is the installation folder for your Siebel Enterprise
    • $DBServerRoot/$DatabasePlatform (For example, "...\dbsrvr\Oracle")
  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 Customer Success Services to request assistance from Oracle’s Application Expert Services.