Creating Indexes Has 8 Tables With Errors Due To Oracle Maximum Index Columns Of 32
(Doc ID 2312635.1)
Last updated on FEBRUARY 05, 2019
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version, Patching and Maintenance
Creating Indexes has 8 tables with Errors Due to Oracle maximum index columns of 32
The following tables are throwing ORA-01793 error. Can you let us know why Oracle is creating tables with 33 indexes when the maximum limit is 32?
ERROR at line 34:
ORA-01793: maximum number of index columns is 32
The issue can be reproduced at will with the following steps:
1. While upgrading noticing error messages with the mentioned tables
2. The following tables are throwing ORA-01793 error.
3. Oracle is creating tables with 33 indexes when the maximum limit is 32?
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