My Oracle Support Banner

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 APRIL 04, 2025

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

To view full details, 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 a vibrant support community of peers and Oracle experts.