DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Maximum

  1. #1
    Join Date
    Oct 2000
    Posts
    7

    Angry

    Hi,

    I would like to know the max. limit of number and size of tables within one database. Thanks a lot.

    Joe

  2. #2
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    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

  3. #3
    Join Date
    Sep 2000
    Posts
    128
    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
  •  


Click Here to Expand Forum to Full Width