非也非也，是1000个，不论8i还是9i。 看看ora-1792即知. oerr ora 1792 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.
column specifies the name of a column of the table. The number of columns in a table can range from 1 to 254.
column Specify the name of a column of the table. If you also specify AS subquery, then you can omit column and datatype unless you are creating an index-organized table. If you specify AS subquery when creating an index-organized table, then you must specify column, and you must omit datatype. The absolute maximum number of columns in a table is 1000. However, when you create an object table (or a relational table with columns of object, nested table,varray, or REF type), Oracle maps the columns of the user-defined types to relational columns, creating in effect "hidden columns" that count toward the 1000-column limit.以上出自SQLReference-oracle9i
看看ora-1792即知.
oerr ora 1792
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.
in a table can range from 1 to 254.
Specify the name of a column of the table.
If you also specify AS subquery, then you can omit column and datatype unless
you are creating an index-organized table. If you specify AS subquery when
creating an index-organized table, then you must specify column, and you must
omit datatype.
The absolute maximum number of columns in a table is 1000. However, when you
create an object table (or a relational table with columns of object, nested table,varray, or REF type), Oracle maps the columns of the user-defined types to
relational columns, creating in effect "hidden columns" that count toward the
1000-column limit.以上出自SQLReference-oracle9i