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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top