Re: maximum number of tables
Posted by: Roland Bouman
Date: April 03, 2006 08:17AM

alex hall wrote:
> Hi
>
> Now I am wondering if this is wise, as the
> database now consists of over 1,400 tables and new
> ones being created hourly. Is there an upper limit

Are you wondering if it is wise, or are you maybe thinking that it was probably not so wise ;-)

> would provide the better solution? Are the issues

That's easy. One table fits all.

> with this type of design?

Yes, lots! instead of maintaining jus one table, you need to maintain thousands...and counting. That means that any optimization or extension you can think of needs to be pushed to all these tables.

I don't know if there are any physical reasons that would stop you from doing this.

Check out this blog: http://bobfield.blogspot.com/2006/03/million-tables.html

Options: ReplyQuote


Subject
Written By
Posted
April 03, 2006 06:21AM
Re: maximum number of tables
April 03, 2006 08:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.