8i, 9i, 10g, 11g 오라클 column 갯수의 제한은 1000개임.
티베로 5 1000개
티베로 6 1500개
https://docs.oracle.com/cd/B28359_01/server.111/b28320/limits003.htm#i288032
======================================
Logical Database Limits
Item Type of Limit Limit Value
GROUP BY clause Maximum length The GROUP BY expression and all of the nondistinct aggregate functions (for example, SUM, AVG) must fit within a single database block.
Indexes Maximum per table Unlimited
Indexes Total size of indexed column 75% of the database block size minus some overhead
Columns Per table 1000 columns maximum
Columns Per index (or clustered index) 32 columns maximum
Columns Per bitmapped index 30 columns maximum
Constraints Maximum per column Unlimited
Subqueries Maximum levels of subqueries in a SQL statement Unlimited in the FROM clause of the top-level query
255 subqueries in the WHERE clause
Partitions Maximum length of linear partitioning key 4 KB - overhead
Partitions Maximum number of columns in partition key 16 columns
Partitions Maximum number of partitions allowed per table or index 1024K - 1
Rows Maximum number per table Unlimited
Stored Packages Maximum size PL/SQL and Developer/2000 may have limits on the size of stored procedures they can call. The limits typically range from 2000 to 3000 lines of code.
See Also: Your PL/SQL or Developer/2000 documentation for details
Trigger Cascade Limit Maximum value Operating system-dependent, typically 32
Users and Roles Maximum 2,147,483,638
Tables Maximum per clustered table 32 tables
Tables Maximum per database Unlimited
'DBMS' 카테고리의 다른 글
Oracle 사용자를 위한 DB2 Conversion 프로젝트, Part 4: DB2 애플리케이션 (0) | 2010.08.09 |
---|---|
오라클 자료형과 MSSQL 자료형 (0) | 2009.10.07 |
오라클 데이터베이스 10g 릴리즈 2편 - 성능 항목별 DBMS 3종 비교 분석 (0) | 2009.08.24 |
플랫폼 다변화를 이끄는 오픈소스 오픈소스 DBMS 라이선스의 이해 (0) | 2009.07.16 |