About DDLDICT
The DDL Dictionary tool is used to compare what is in the logical schema, as defined in the Repository, with the physical schema as defined in the database itself, and generate the DDL necessary to reconcile these two.
Basic Usage of DDLDICT
The DDLDICT utility is run in any of the following situations:
- During a Fresh Database Installation (automated)
- During a Database Upgrade/IRM (automated)
- During Migration from a Development (DR) to a downstream (RR) environment (automated)
- During execution of PostInstallDBSetup or RepositoryUpdate
- When applying new schema changes made in Siebel Tools.
Generally, it is run just before the DDLIMP utility to provide the input file needed to reconcile the physical and logical schemas.
Command Line Arguments
| Flag | Parameter | Required | Default | Description |
|---|---|---|---|---|
| ⁄u | Username | Yes | N/A |
The Siebel Username (typically "SADMIN") See also ⁄6 argument below. |
| ⁄p | Password | Yes | N/A | The password for the user chosen for the ⁄U argument |
| ⁄c | ODBC Data Source | Yes | Env Variable SIEBEL_DATA_SOURCE | The ODBC source for the database connection. This must already exist. |
| ⁄d | Siebel Table Owner | Yes | Env Variable SIEBEL_TABLE_OWNER | The tableowner login name (typically "SIEBEL") |
| ⁄f | DDL Filename | Yes | N/A | The name of the file where the logical schema should be written |
| ⁄i | Export Indexes | No | Y | Whether or not to include index definitions in the output file. |
| ⁄t | Export Table Types | No | DCIWER |
Allows selection of specific table types. This should be a string of letters with no spaces or commas from the following set.
|
| ⁄e | Export Entire Schema | No | N | Whether are not to export all schema elements. This defaults to "N" because in many situations, you will specify the ⁄T, ⁄I, or other arguments that limit to a specific subset of tables and want only that subset, not the entire schema. |
| ⁄k | Table Name Like Support | No | Y | |
| ⁄n | Repository Name | Yes | N/A | Typically, "Siebel Repository" |
| ⁄a | Ignore Dictionary Cache | No | N |
The "Dictionary Cache" (diccache.dat) is a file version of the logical schema used by EIM and other batch components. As a file, it is faster to read as compared to querying the database, so using it is faster. However, if the state of that cache is unknown (that is, is it up-to-date?), override the default of "N" with "Y" to force ddldict to read directly from the Repository. |
| ⁄l | Log Filename | No | ddldict.log | The name of the file where information is logged to assist with troubleshooting failures. |
| ⁄w | Language to run program in | No | ENU | This chooses the language for log files; it has no impact on functionality. |
| ⁄6 | Specify Siebel Username when DB User is not a Siebel user |
Sometimes |
N/A | It is possible to run this utility as a user that is not defined as a Siebel user. For example, the DBA could run this utility using system credentials for the ⁄U and ⁄P parameters. In that scenario, an actual Siebel user – one who exists as an Employee in the Siebel database – must be specified using this argument (typically, SADMIN). |