I would like to know the max. limit of number and size of tables within one database. Thanks a lot.
Table size: limited by max file size
Field size in bytes: 2 GB
Rows per table: limited only by file size
Tables per database: up to 32,767
The maximum number of Oracle blocks per file is also limited, so assuming your OS can handle huge files, the maximum would be:
.. not really an issue for most databases!
Click Here to Expand Forum to Full Width