RE: IOT instead of a large partitioned table

We're using large file systems on AIX 4.3.3 which allow us up to 31.99999G data files.

Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
pnbarne_at_regence.com

On Tue, 12 Sep 2000, Ronen Levit wrote:

> Richard,
>
> Sorry, but I don't recall any OS in particular (we're using NT & Solaris).
>
> Ronen.
>
> -----Original Message-----
> Sent: Monday, September 11, 2000 10:10 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Ronen,
>
> Do you know Oracle on which OS allows extent size to be greater than 2GB?
> My understanding (from metalink) is that this restriction applies to all OS
> platforms.
>
> Richard Ji
>
> -----Original Message-----
> Sent: Monday, September 11, 2000 12:20 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Eduard,
>
> We're using such IOT here, holding 18gb of data in such table.
>
> Pay attention that each extension should be no more than 2GB (in some OS
> it's a restriction , but it is recommended anyway).
>
> Besides, no problem that we encountered with this size ... but we're still
> developing ...
>
> Let me know how you're doing with it, please.
>
> Ronen Levit
> Database group manager
> Talmai
> Tel: +972 8 9460606 #212
> Fax: +972 8 9460705
> Cell: +972 52 448699
>
>
>
> -----Original Message-----
> Sent: Monday, September 11, 2000 5:03 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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?
>
>
> Ed
>
> --
> Author: Shevtsov, Eduard
> INET: EShevtsov_at_flagship.ru
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Ronen Levit
> INET: ronen.levit_at_talmai.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author: Richard Ji
> INET: richard_at_letsplay.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Ronen Levit
> INET: ronen.levit_at_talmai.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Sep 12 2000 - 12:22:18 CDT