At a typical customer site, the IT department will already have multiple relational databases in place for their existing enterprise systems. To prepare the installation of Siebel CRM, we have to ensure that sufficient tablespace is provisioned on the RDBMS.
The following is an example for the Oracle database and assumes that the Oracle RDBMS has already been installed and a database instance has been created following the instructions in the Siebel Installation Guide.
We can use an SQL script similar to the sample code below via the command line or any suitable software tool to create two tablespaces, one for the Siebel tables and the other for the indexes. This is a recommended practice as the Siebel installation wizard will prompt us for the names of two tablespaces.
rem ================================================ rem create initial tablespace for Siebel data tables rem ================================================ CREATE SMALLFILE TABLESPACE "SIEBELDB_DATA...