Results 1 to 6 of 6
  1. #1
    Join Date
    May 2006
    Posts
    3

    Unanswered: limits with oracle

    which is the maximum number of tables for each oracle database?

    Thank you

  2. #2
    Join Date
    Jan 2004
    Posts
    492
    Not sure of the exact number, but if you ever approached the limit (whatever it is) I would be interested in knowing exactly what type of application you are building.
    Oracle OCPI (Certified Practicing Idiot)

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    nibs, you asked this exact same question in the postgresql forum, and also the mysql forum

    why oh why haven't you also asked this question in the sql server forum?

    and what the heck are you doing designing an application that can run on multiple database platforms, if you are anywhere near close to hitting a limit on the number of tables?

    you're not thinking of one set of tables per user, are you?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    The Oracle docs (link provided by beilstwh) say the number of tables is "unlimited". However, of course you are restricted to 30 character names, and those characters must come from the set {A-Z,a-z,0-9,_,$,#). So in fact the maximum number of tables in a single schema is 65^30, or about 2,440,000,000,000,000,000,000,000,000,000,000,000, 000,000,000,000,000,000.

    I hope that isn't too restrictive

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by andrewst
    The Oracle docs (link provided by beilstwh) say the number of tables is "unlimited". However, of course you are restricted to 30 character names, and those characters must come from the set {A-Z,a-z,0-9,_,$,#). So in fact the maximum number of tables in a single schema is 65^30, or about 2,440,000,000,000,000,000,000,000,000,000,000,000, 000,000,000,000,000,000.

    I hope that isn't too restrictive
    Tony,
    You have made my day. Very, very funny (at least to a geek like me).
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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