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 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------