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)

The size of the database is limited in 7.2 or less to about 1022 files which probably varies per operating system.

Since every row in a table has a ROWID you can probably dismember that and determine the maximum possible that way. It will of course depend on your block size and how many rows you can fit per block.

--
  -----------------
   T T T T T T T T        Bruce Pihlamae
   I I I I I I I I        bpihlama_at_nla.gov.au
   I I I I I I I I        National Library of Australia
   T T T T T T T T        Phone: +616 262-1575
  -----------------       Fax:   +616 273-2116
 ===================
 "If you swallow a live frog first thing in the morning;
  nothing worse will happen to either of you that day."