ORA-01792 on copying a DB2 table layout into an Oracle database
How do I get over this error?
ORA-01792: maximum number of columns in a table or view is 254
I was copying a DB2 table layout into an Oracle database for a migration exercise, but I have exceeded the number of columns allowed.
Try using the heterogeneous gateway to do CTAS against this large table to reduce the number of columns by creating two or more tables. Since you are allowed over a 1000 columns, I am not sure I want to know how the source database was designed. However, it sounds like you have many more experiences ahead converting this to Oracle. (CTAS – create table as select, for example: create table emp2 as select * from emp@other_db;)
This was first published in September 2004