RE: IOT instead of a large partitioned table

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-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ronen Levit Sent: Monday, September 11, 2000 12:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: IOT instead of a large partitioned table

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