ORA-01792: maximum number of columns in a table or view is 1000
ORA-01792: maximum number of columns in a table or view is 1000
This limit is not only applicable to tables and views, but also on the temporary inline view and the temporary internal memory tables which Oracle creates while executing a subquery.
For example,
Oracle creates a temporary inline view based on the merge select, thus the same restriction is implemented on this temporary inline view. So, you need to make sure that the number of columns in a sub-select or subquery also doesn't exceed this limit of 1000.
Caused by: org.hibernate.exception.SQLGrammarException: could not initialize a collection:
The above error indicates that you are trying to create a collection which exceeds the limit of number of columns allowed, i.e. the total number of columns exceeds 1000.