| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Huge Partitions and Indexes, maybe compression
We're HP-UX and Oracle 8.1.7.4.
We've got some BIG partitioned tables, but got to thinking. They want to keep 5 years. If down the road we get to perhaps 400-800gb in some of these and an index gets corrupted, what can we do about it? The table will be so large we'd never be able to rebuild.
There is a thought we could use compressed indexes and that may help a bit, but as far as I know, there are no compressed tables yet.
Even so, does that eliminate the problem?
Once these things get built that large what can one do about a rebuild? It would take days to reload the table. Do the matching indexes stay so isolated from the other partitions that rebuilding the index would only be one partition and this is of little concern?
--
Michael Kline, Principle Consultant
804-744-1545
 |
 |