Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle 8i row size limitation
- Thread starter GT98SVO
- Start date
The size and number of rows is essentially unlimited. Oracle can store extremely long rows in overflow segments. That's unlike a database like SQL Server, which has to have an entire row fit on an 8k page. Similarly there is no real limit on the number of rows in a table. You can store as many rows as you have disk space available. There is undoubtedly some theoretical limit, probably based on the maximum number of rowids, but I've never heard of a real table coming close to this limit.
- Thread starter
- #3
- Status
Similar threads
