Maximum

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.