Some background information:
Oracle 21c 64-bit
I created a series of 5 views and and trying to consolidate them into 1 "super" view.
Under Oracle 11g I was able to do this with no issues.
Now, using Oracle 21c I am getting the ORA-01790 error.
In trying to resolve the issue I used Oracle SQL Developer to list the columns in the view and compare the attributes of each column: name, precision, etc. I did not find any anomalies.
I exported the above and imported into Excel, and then using Beyond Compare I was able to compare the 2 results; I did not find any differences.
I uploaded the 2 Excel spreadsheets for anyone to examine, maybe I missed something obvious.
I don't know where to look next; any ideas would be appreciated.
Thanks
Murray
FwSalesHistory6AdjustV.xlsx
Uploaded Mar 23, 202224.76 KB
FwSalesHistoryDetailV.xlsx
Uploaded Mar 23, 202222.8 KB