Home » SQL & PL/SQL » SQL & PL/SQL » How Many columns can we create in oracle 9i table?
How Many columns can we create in oracle 9i table? [message #186324] Mon, 07 August 2006 08:52 Go to next message
sam_dinesh
Messages: 18
Registered: February 2006
Location: india
Junior Member

No Message Body
Re: How Many columns can we create in oracle 9i table? [message #186325 is a reply to message #186324] Mon, 07 August 2006 08:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1000?
Re: How Many columns can we create in oracle 9i table? [message #186330 is a reply to message #186325] Mon, 07 August 2006 09:19 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
From the documents.

Quote:

ORA-01792 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:

If the table contained unused columns, remove them by executing ALTER TABLE DROP UNUSED COLUMNS before adding new columns.
Reduce the number of columns in the command and resubmit.

Previous Topic: Datatype Conversion
Next Topic: Query Help
Goto Forum:
  


Current Time: Sun Dec 04 20:29:12 CST 2016

Total time taken to generate the page: 0.12527 seconds