Siebel Data Warehouse Installation and Administration Guide > Applying SIF Patches >

Applying the SIF Contents to the Schema

After importing and verifying the s_etl_ref_param.sif file, you must apply it to the Siebel transactional database schema.

To apply the SIF contents to the physical OLTP schema

  1. In Siebel Tools, in the Object Explorer, click on the Table tab and query for S_ETL_REF_PARAM (the list of tables affected by the imported SIF file).
  2. Click Apply. You may get the warning message: "You are connected to a local database ...," but this may be ignored.
  3. The Apply Schema wizard appears. In the Tables drop-down menu, select Current Query. Fill in the appropriate values for the following parameters:
    • Table space.
    • 16K table space.
    • 32K table space.
    • Index space.
    • Privileged user ID.

      Privileged user id should correspond to the database tableowner.

    • Privileged user password.

      Privileged user password should correspond to the database tableowner password.

    • ODBC data source.

      NOTE:  Leave the Table groupings file parameter blank.

  4. After filling in the parameters above, click Apply. Siebel Tools modifies the physical schema of the database. This may take 5 to 10 minutes. If the process is successful, Siebel Tools returns the message "Changes successfully applied."

    If an error message is returned, check that the parameters you entered are correct and try applying the schema again.


 Siebel Data Warehouse Installation and Administration Guide
 Published: 09 September 2004