How to eliminate Oracle DB "Chained Rows" because of long fields set (>255) in standard tables (S_ORG_EXT, S_ASSET, S_CONTACT, S_EVT_ACT etc)? (Doc ID 2044575.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1 [21112] and later
Information in this document applies to any platform.

Goal

QUESTION:
---------------
Some Siebel CRM standard tables have the number of columns greater than 255. Lot of columns are empty.
For example: S_ORG_EXT, S_ASSET, S_CONTACT, S_EVT_ACT.

In the Oracle DataBase of Siebel CRM this fact creates the "chained rows".

References about the matter of the "chained rows":

 

Are any restrictions to drop unusable columns?
 

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