k_murli_krishna
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Andrew
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.