Re: debunking partitioning

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 04 Dec 2002 00:20:03 +0100
Message-ID: <hvequus46k32ll20q577it80j4b1kdlqpc@4ax.com>

On 3 Dec 2002 14:31:19 -0800, mikharakiri_at_yahoo.com (Mikito Harakiri) wrote:

>CREATE view sales_range as
>select * from sales_jan2000
>union all
>select * from sales_feb2000
>union all
>select * from sales_mar2000
>...
>
>I wish partitioned tables were designed as updateable views like
>sales_range above!

They have been. Trust me: the performance was very lousy and the administration was a nightmare. Hence partition views have been removed.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Dec 03 2002 - 17:20:03 CST