Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Guidelines for Configuring the RDBMS > Creating Oracle Database Objects >

Creating Oracle Tablespaces

Initial (Minimum) tablespace allocation recommendation is as follows:

• Data—5 GB
• Index—5 GB
• Rollback segment—1 GB

This allocation is enough for a fresh installation of Oracle 8i (non-Unicode-enabled) or Oracle 9i (Unicode- or non-Unicode-enabled).

The following additional guidelines should help you in creating tablespaces:

• To improve performance on your production system, create at least two tablespaces for Siebel implementation—one for indexes and one for data.
• Distribute objects that you anticipate to be large or points of contention by creating additional separate tablespaces (preferably on separate disk devices).
• Be sure that you, or whoever is responsible for setting up permissions, grants the Siebel tableowner account the privilege and sufficient quota to create tables and indexes in these tablespaces.

  Besides the tableowner, the database User ID used for Siebel Marketing also requires additional rights at the database level within the OLTP schema. You must grant drop table, drop index, create table, and create index rights to this user. For more details, see Siebel Marketing Installation and Administration Guide.

• Set storage parameters for your data and index tablespaces. The Siebel installation procedure does not set storage parameters for the objects it creates. The storage configuration for each objects follows the default storage parameters of its tablespace.

  In a development or test environment, multiple Siebel eBusiness Applications installations can coexist on one Oracle instance. Each Siebel installation can be installed under one tableowner. For example, more than one test environment can share one Oracle instance.