Home » SQL & PL/SQL » SQL & PL/SQL » Maximum Number of Tables
Maximum Number of Tables [message #198408] Tue, 17 October 2006 02:03 Go to next message
balmcacit05
Messages: 6
Registered: July 2006
Junior Member
Hi

I have a doubt. what is the maximum number of tables that a dbms can contain (for eg Oracle 9i).
Re: Maximum Number of Tables [message #198413 is a reply to message #198408] Tue, 17 October 2006 02:16 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
For your purposes, unlimited.

Really, as database object has a limit in name length to 30 characters, count all possible permutations and you'll get the exact number.

Unlimited, as I've said.
Re: Maximum Number of Tables [message #198416 is a reply to message #198408] Tue, 17 October 2006 02:20 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
To the best of my knowledge, there is no limit.
In the obj$ table, the Object_id is held as a Number, so I guess that would impose a limit of something like 10^38 tables (less a few for the system objects)

More than you could ever need is a good summary, I think.
Re: Maximum Number of Tables [message #198442 is a reply to message #198408] Tue, 17 October 2006 03:45 Go to previous messageGo to next message
balmcacit05
Messages: 6
Registered: July 2006
Junior Member
Hi,

First of all thanks for all your replies.

Does this limit depend on the size of DBMS and does it vary from one DBMS to other
Re: Maximum Number of Tables [message #198444 is a reply to message #198442] Tue, 17 October 2006 03:50 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
How do you mean 'Does this vary with the size of the DBMS'?

Can larger databases have more tables?
You question makes no sense.

'Does this vary with the DBMS'
Well, unless there's some agreement I haven't heard of between all the database manufacturers to agree a comment limit, then I'd have to say 'Yes'
For example, in Access 2.0, the maximum number of tables plus queries in the database is 32767.

Really, you should learn to use Google for simple questions.
Previous Topic: logic help
Next Topic: Regarding declarations in SP's
Goto Forum:
  


Current Time: Sun Dec 04 16:38:19 CST 2016

Total time taken to generate the page: 0.18155 seconds