Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
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
- 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).
- Click Apply. You may get the warning message: "You are connected to a local database ...," but this may be ignored.
- The Apply Schema wizard appears. In the Tables drop-down menu, select Current Query. Fill in the appropriate values for the following parameters:
- 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.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide Published: 09 September 2004 |