All additions and modifications to data layer object types such as tables, columns, indexes, and user keys must become manifest in the physical database.
To accomplish this, Oracle provides two utilities, which we will discuss in this section:
Siebel Tools Apply feature
Synchronize Schema Definition process (ddlsync)
The Siebel Tools Apply feature is typically used by developers against their local databases but it also works against server databases.
The Synchronize Schema Definition process is intended for use against server databases and helps in automating the synchronization of the Siebel Repository metadata information against a physical database.