RE: Huge Partitions and Indexes, maybe compression
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 29 Mar 2004 15:38:30 -0500
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:
1) Table compression does exist in 8.1.7. Haven't tried it, yet.
2) Find your largest index, maintain 3 times that in free disk space so
that you can rebuild.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: mkline1@xxxxxxxxxxx [mailto:mkline1@xxxxxxxxxxx]
Sent: Monday, March 29, 2004 2:58 PM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
