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 laterInformation 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":
- http://www.orafaq.com/wiki/Chained_row
- https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:358341515662
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! |