What is the maximum number of columns a database table can have ? Is there a limit on that ? Thanks in advance.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by Christian13467 · Jan 13, 2010 at 12:36 PM
The maximum is 1000 columns per table or view.
Answers Answers and Comments
No one has followed this question yet.
Relationship among database, tablespace and data file ?
How to add one more field to the below existing table ?
If the large table contains thousands of records and the application is accessing 35% of the table which method to use ?
Alter temporary table throws ORA-14450
Between EXISTS and In which one is more performance friendly ?