-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|