Q

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

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close