any limitations for table spaces memory sizes for users ? [message #74518] |
Thu, 23 December 2004 18:55 |
Mohan G
Messages: 36 Registered: August 2004
|
Member |
|
|
hello
i have around 100 tables in my project. so can i go with one user only or should i create more than one user. i mean is there any limitations/restrictions in memory sizes for table spaces,indexes or any others.
some one please guide me
Moahn G
|
|
|
Re: any limitations for table spaces memory sizes for users ? [message #74519 is a reply to message #74518] |
Thu, 23 December 2004 20:58 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
With a small 100 table schema you are unlikely to hit any sort of limit. So, it boils down to personal choice and what makes sense.
But if you insist, database limits are documented in the Oracle Database Reference Guide. Examples:
Tablespaces - 64000 max
Indexes - Unlimited
Users and roles - 2,147,483,638 max
Best regards.
Frank
|
|
|
|
|