Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: is there limit to number of partitions in a table

Re: is there limit to number of partitions in a table

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 10 Mar 2004 05:09:51 -0800
Message-ID: <1a75df45.0403100509.5da7ccb2@posting.google.com>


colin_lyse_at_yahoo.com (colin_lyse) wrote

> we have a very large table (starting at 1 billion growing by 4 million a day
> we will keep 2 years - 2 billion rows) that has to be partitioned. Is there a
> limit ot number of partitions, not necessarily a physical limit, more of a
> partical limit. We are thinking of creating ~104 partitions (1 per week, 20
> million rows), is that execessive.

No, not IMO. I would think 1000+ partitions may become a problem.

> what if we subpartion each of those by say 4 partition giving us 416
> partitions is that execessive will it cause problems for us?

Best see Metalink note id 76765.1 (Maximum Number of Partitions Allowed on a Table).

--
Billy
Received on Wed Mar 10 2004 - 07:09:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US