ORA-01792 “maximum number of columns in a table or view is 1000”

22 Sep

a)    Texte aus oerr unter Linux
01792, 00000, “maximum number of columns in a table or view is 1000”
// *Cause: An attempt was made to create a table or view with more than 1000
//         columns, or to add more columns to a table or view which pushes
//         it over the maximum allowable limit of 1000. Note that unused
//         columns in the table are counted toward the 1000 column limit.
// *Action: If the error is a result of a CREATE command, then reduce the
//         number of columns in the command and resubmit. If the error is
//         a result of an ALTER TABLE command, then there are two options:
//         1) If the table contained unused columns, remove them by executing
//            ALTER TABLE DROP UNUSED COLUMNS before adding new columns;
//         2) Reduce the number of columns in the command and resubmit.

b) Erklärung
Dieser Fehler tritt auf, wenn eine Tabelle mit mehr als der zulässigen Anzahl von 1000 Spalten angelegt werden soll.

c) Lösung
Die Anzahl der Spalten in dem Statement “create Table” verringern.

Diesen Artikel teilen :Share on Google+Share on LinkedInTweet about this on TwitterShare on Facebook

Tags: