Reader small image

You're reading from  Oracle Siebel CRM 8 Developer's Handbook

Product typeBook
Published inApr 2011
Reading LevelIntermediate
Publisher
ISBN-139781849681865
Edition1st Edition
Languages
Concepts
Right arrow
Author (1)
Alexander Hansal
Alexander Hansal
author image
Alexander Hansal

Alexander Hansal has worked as an IT professional in small, medium, and global corporations. Since 2001, Alexander works as a technical instructor and consultant for Siebel CRM and Oracle Business Intelligence in Europe. He enjoys teaching, and shares his knowledge and expertise in his classes at Oracle University and in his weblog, http://siebel-essentials.blogspot.com/
Read more about Alexander Hansal

Right arrow

Applying schema changes to local and server databases


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.

Using the Siebel Tools "Apply" feature

The following procedure describes how to use the Siebel Tools Apply feature against a local developer database or the Siebel Sample database to create new columns, indexes, and tables. We will use the tables created or modified in the case study examples...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Oracle Siebel CRM 8 Developer's Handbook
Published in: Apr 2011Publisher: ISBN-13: 9781849681865

Author (1)

author image
Alexander Hansal

Alexander Hansal has worked as an IT professional in small, medium, and global corporations. Since 2001, Alexander works as a technical instructor and consultant for Siebel CRM and Oracle Business Intelligence in Europe. He enjoys teaching, and shares his knowledge and expertise in his classes at Oracle University and in his weblog, http://siebel-essentials.blogspot.com/
Read more about Alexander Hansal