Link to home
Start Free TrialLog in
Avatar of k_murli_krishna
k_murli_krishnaFlag for India

asked on

maximum columns in a table

1) How many columns can we include in a create table statement.
2)Does it depend on data types and sizes of the columns.
3) Is there a concept called page size in oracle. If so, what is it?

--- k_murli_krishna
ASKER CERTIFIED SOLUTION
Avatar of pennnn
pennnn

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mark Geerlings
1. That depends on your version of Oracle, the limits are higher in the higher versions.  I have never come close to the limit of columns in a table, so I don't pay much attention to the actual limit in each version.

2. No, unless you use some of the newer object types or user-defined types, but if you do use these then yes, because Oracle will then automatically create some additional hidden columns that must be included in the total number of columns.

3. No, not as far as I know.  Oracle stores data in blocks.  These are grouped into extents and segments.  Thay are contained in datafiles and tablespaces.
Avatar of asimkovsky
asimkovsky

The concept of a "page size" is relevant to SQL Server, but it is basically the same concept of datablocks in Oracle. Oracle calls them datablocks, and SQL Server calls them pages.


Andrew