My Oracle Support Banner

While Applying Patch 30399999 Error 'table EGO_BULKLOAD_INTF is missing the column C_INTF_ATTR9#1' (Doc ID 2761449.1)

Last updated on MARCH 17, 2021

Applies to:

Oracle Product Hub - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Patch Application Issues

Patch: 30399999 apply fails on egot047.odf with error ORA-1792
 
Verified the issue in the log file as noted below:

Error
The table EGO_BULKLOAD_INTF
  is missing the column C_INTF_ATTR9#1.

Add the column with the statement:


Start time for statement below is: Wed Mar 17 2021 00:44:18

ALTER TABLE EGO.EGO_BULKLOAD_INTF ADD ( C_INTF_ATTR9#1 VARCHAR2(4000) )

AD Worker error:
The following ORACLE error:

ORA-01792: maximum number of columns in a table or view is 1000

Steps
The issue can be reproduced at will with the following steps:

1. Apply Patch: 30399999

2. Above error appears in Log file


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.