Siebel IRM Failed In TEST Environment : Unable To Allocate New Pages In Table Space "SIEBEL_IXSPACE" (Doc ID 1955545.1)

Last updated on JULY 20, 2016

Applies to:

Siebel Financial Services CRM - Version 8.1.1.11 [23030] and later
Information in this document applies to any platform.

Goal

Qn1:On checking the upgrade logs you have observed that the same scenario is observed for the table S_EMP_PER related indexes.

S_EMP_PER was allocated Index tablespace "SIEBEL32K_IXSPACE" prior to the Upgrade. But the upgrade utility have moved all this tables indexes to Index tablespace "SIEBEL_IXSPACE", which is not expected of the Upgrade.

You would like to know the reason for the index space moved.
 
Qn2:You would like to know how to create the tables and indexes EIM and non-EIM table that are new in their respective tablespaces and index spaces.
 
Qn3:can schema.ddl be edited to include custom tablespaces and custom index spaces.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms