RE: IOT instead of a large partitioned table

You can check for File Restriction Limit on different Platform from Metalink with DocId given Below

         AIX (RS6000 / SP)       [NOTE:60888.1]
         HP                      [NOTE:62407.1]
         Digital Unix            [NOTE:62426.1]
         Sequent PTX             [NOTE:62415.1]
         Sun Solaris             [NOTE:62409.1]

         Windows NT              Maximum 4Gb files on FAT
                                 Theoretical 16Tb on NTFS
                                 ** See [NOTE:67421.1] before using large files
                                    on NT with Oracle8
                                 *2 There is a problem with DBVERIFY on 8.1.6
                                    See [BUG:1372172]

Inderpal Johal

Peter Barnett <pnbarne_at_shep.bcbso.com> on 09/12/2000 02:25:23 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Indy Johal/PR Newswire)

Subject: 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
> also send the HELP command for other information (like subscribing).
>

--
Author: Peter Barnett
  INET: pnbarne_at_shep.bcbso.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