Max Tables per Database/Tablespace?

From: James Hanway <hanwayj_at_dfo-mpo.gc.ca>
Date: Tue, 23 Nov 1999 18:07:21 GMT
Message-ID: <383AD7E2.D071A090@dfo-mpo.gc.ca>

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?

Max number of rows per table?

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

Cheers!

James Received on Tue Nov 23 1999 - 12:07:21 CST