SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user650888Jan 17 2020 — edited Jan 21 2020

I have a query, select * from view

This query is not giving any error in one instance, but its giving error in another instance....is there any environment setting that can be changed in the instance where I get this problem ?

I counted the columns, its not coming to be 1000

This post has been answered by Jonathan Lewis on Jan 17 2020

Jump to Answer

Added on Jan 17 2020

14 comments

879 views