Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: debunking partitioning
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