Re: Maximum tables in an instance?

According to the 7.3 server refrence, there is no limit for the number of tables in a database. There is a limit of 32 tables in a cluster.

Mark Landa wrote:
>
> There probably is a limit (which I don't know,
> there is limit to everything), but 3500 is no problem,
> I am guessing not even close to the limit.
> I currently have approx. 6500 tables/views and
> another approx. 16,500 in other objects (packages,procs,synonyms,
> functions, indexes,etc) in our DB.
>
> M.Landa
>
> David Myers wrote:
>
> > Is there a maximum limit of tables to an instance? ... to a database?
> > I'm looking at needing around 3500 tables in an instance or splitting them
> > amoung two instances. Any help would be greatly appreciated.
Received on Tue Feb 17 1998 - 00:00:00 CST