ORA-01792 appears to be a logical error which means you are attempting to create a table or view with more than 1000 columns or adding columns to an existing table or view resulting in 1000+ columns, however if you are on 12cR1 and above and receiving ORA-01792 from a Select statement then this can be…