Re: Maximum tables in an instance?

From: Bryan Lenihan <bryanle_at_lenisoft.com>
Date: 1998/02/07
Message-ID: <6bgvt6$79b@bgtnsc02.worldnet.att.net>#1/1

My production database has well over 4000 tables. I do however have them split up between 2 schemas of about 2800 tables a peice. I do not think that you will have a problem??? But I have not tested with all tables under 1 schema.

Thanks,
Bryan Lenihan

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 Sat Feb 07 1998 - 00:00:00 CST