Re: Disadvantges of 1-partition tables

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 13 Sep 1999 20:08:27 +0800
Message-ID: <37DCE93B.408C@yahoo.com>

Trevor Williams wrote:
>
> Partitioned tables have a number of advantages over normal tables, not the
> least being the ability to move the data around without dropping the table.
> So I am thinking about creating all tables as partitioned tables?
>
> Before I do, I am trying to determine:
> What are the disadvantages of a single-partition table over a normal table?
> (or, why should I stick with normal tables?)
>
> I will appreciate any thoughts on this.
>
> Thanks
> Trevor

Oracle allows facility to "convert" between tables and partitions so I don't think you would need to have the single partitions that you describe..

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Sep 13 1999 - 07:08:27 CDT