Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    inida
    Posts
    62

    Smile Unanswered: Number of records?

    i would like to know the number max number of records a table can hold in Oracle 8i and 9i

    Tanx

  2. #2
    Join Date
    Feb 2004
    Posts
    143
    I don't think there is any maximum limit on the number of records a table can have...(unless you run out of space in the tablespace of that table)

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    I agree; the only time I've ever reached a limit it's been because of the size of the tablespace, and increasing it allowed me to carry on adding records.

    The only 'limit' may be imposed by the users i.e. performance issues.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    It is "unlimited" according to the Oracle 9.2 Database Reference

    However, given the format of a ROWID 'OOOOOOFFFBBBBBBRRR', I suppose there is an upper limit imposed by the number of possible distinct ROWID values, i.e. 64^18 (since each of the 18 characters in the ROWID can have one of 64 values). That's probablly more rows than there are particles in the universe or something, so is effectively "unlimited"!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •