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.
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:
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
The issue can be reproduced at will with the following steps:
1. Apply Patch: 30399999
2. Above error appears in Log file
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