| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Huge Partitions and Indexes, maybe compression
Michael,
As one who has been headed down that path for some time, believe me it is possible (without new hardware). What you need is:
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: mkline1_at_comcast.net [mailto:mkline1_at_comcast.net]
Sent: Monday, March 29, 2004 2:58 PM
To: oracle-l_at_freelists.org
Subject: 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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |