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 last published in September 2004

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close