Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> IOT instead of a large partitioned table
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
![]() |
![]() |