Error when running Upgrade DB script - during Patching CP4
search cancel

Error when running Upgrade DB script - during Patching CP4

book

Article ID: 231567

calendar_today

Updated On:

Products

CA Identity Governance

Issue/Introduction

While running DB upgrade script during patching 14.2 CP4

Script is a part of patching file, this script is not successful

DB version: 19c

 

UPGRADE_SDB_ORACLE.sql -> Run this script on the SDB database.

Error Details:
ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces
ORA-06512: at line 19
01429. 00000 -  "Index-Organized Table: no data segment to store overflow row-pieces"
*Cause:    No overflow segment defined.
*Action:   Add overflow segment.

 

Environment

Release : 14.2

Component : GovernanceMinder(Role & Compliance Manager)

Resolution

able to fix the issue by adding a overflow segment.
'ALTER TABLE BusinessFlowEntities ADD OVERFLOW';