Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: Oracle8i Partitioning
Nuno Souto wrote:
>
> D Hoffman doodled thusly:
>
> >
> >Is there anyone using partitioning on a segment with more
> >than 1000 partitions? If so, are there any risks or noticeable impacts to
> >the database?
> >
>
> Jonathan for sure must have done this before. He's usually the one
> that stress tests Oracle in extreme situations. If he doesn't drop in
> on this, go to his www site:
>
> http://www.jlcomp.demon.co.uk/
>
> and ask the man himself.
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Not that I'mn trying to stand on the shoulders of giants, I've done a similar exercise with approx 2000 partitions (5 years of 1 day partitions) - after having a discussion with Johnathan of course :-)
All the standard partition stuff - add/drop/blah/blah works as per normal. The main things that caused us grief were:
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..." ========= WAS CANCELLED BY =======: From: Connor McDonald <connor_mcdonald_at_yahoo.com> Control: cancel <3C51CFC7.21_at_yahoo.com> Subject: cmsg cancel <3C51CFC7.21_at_yahoo.com> Date: Mon, 28 Jan 2002 01:00:41 GMT Message-ID: <cancel.3C51CFC7.21_at_yahoo.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!fu-berlin.de!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40721745 This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.Received on Fri Jan 25 2002 - 15:36:07 CST