Re: Maximum number of records per table

>txu_at_softart.com wrote:
>>
>> Hi, Folks,
>>
>> What is the maximum number of records allowed per table for oracle?
>> Is there such kind of limits at all?
>>
>> Any suggestions will be greatly appreciated.
>>
>> Tingting (txu_at_softart.com)
>Hi stranger:
> There is no such of limits for Oracle (at least Oracel did not
 document>this limitation).
> I personaly saw table with 1.8 mln. records (11.4 Gb in data + indexes
>extents) and heard from pretty honest guy about 11 mln. records.
>By the way, have somebody seen one with more then 30 mln. or 100 GB ?
>Eugene.

At one site where i work there is a table with 150 mln records in it. Because the records are not that big, the table size is appr 50 Gb (excluding indexes). I don't think however that this is a record.

Stephan Okhuijsen
Senior Consultant Received on Fri Jul 12 1996 - 00:00:00 CEST