Ask the Expert

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: