Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> IOT instead of a large partitioned table

IOT instead of a large partitioned table

From: Shevtsov, Eduard <EShevtsov_at_flagship.ru>
Date: Mon, 11 Sep 2000 11:41:19 +0400
Message-Id: <10616.116611@fatcity.com>


Hi List

I'm going to use IOT instead of a large table. The table contains historical data with a periodical purging from the lowest partition. The approx. size of the table is a range about 100,000,000 - 300,000,000 rows. The table has the only 2-columns PK's index and first column is a partition key (date). Does anybody have any problems with such big partitioned IOTs?  

Any comments? Received on Mon Sep 11 2000 - 02:41:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US