Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: partioning option not worth it?
Pete Sharman <peter.sharman_at_oracle.com> wrote in message
news:yy9d8.5$7a2.139_at_inet-nntp1.oracle.com...
> You've left out one key advantage - availability i.e. if you lose a disk
> with some partitions on it you may still be able to get to the other
> partitions (depending on the query of course). And then there's the
simpler
> (and faster) backup for tables that have lots of read-only partitions
(which
> can be the case fairly often).
>
I appreciate that this can be an advantage, but these advantages are also the same if you just create N tables (although you might have to spend a minute or so modifying any union-all views to exclude the missing partitions. Received on Thu Feb 21 2002 - 14:17:24 CST