Hi,
I would like to know the max. limit of number and size of tables within one database. Thanks a lot.
Joe
Printable View
Hi,
I would like to know the max. limit of number and size of tables within one database. Thanks a lot.
Joe
hi,
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:
4194302*DB_BLOCK_SIZE.
.. not really an issue for most databases!
Terry.