Re: Max Tables per Database/Tablespace?

A copy of this was sent to James Hanway <hanwayj_at_dfo-mpo.gc.ca> (if that email address didn't require changing) On Tue, 23 Nov 1999 18:07:21 GMT, you wrote:

>Afternoon/Morning all,
>
>I am designing a new database on Oracle7.3.4 under Digital UNIX 4.0D
>which could potentially require a large number of tables to organize the
>data.
>
>Does anyone know of an upper limit in v7.3.4 for the number of tables
>you can have in a database or a tablespace?
>

none

>Max number of rows per table?
>

limited by disk space available and the max size of a 7.x database. that size is typically 32 terabytes. In 8.0 and up, max size is much higer

>Max number of tablespaces per DB? I assume this one is based on the
>maxdatafiles parameter as each tablespace requires at least 1 datafile.
>

1022 = max files = max tablespaces.

64k = max tablespaces in 8.0 and up.

>Cheers!
>
>James

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Nov 23 1999 - 12:39:36 CST