Siebel Database Upgrade Guide > Performing the Siebel Incremental Repository Merge > Process of Regenerating the Siebel Repository Definition Files >
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
- 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
- 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.
- 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.
|