MAX. NO OF SCHEMA

[edsperez]

Guys,

Is there anybody who knows what is the maximum number of users that we can create within an Oracle database?

Ed

[sreddy]

I Guess... Users including roles=10K

[jmodic]

I'm sure this is realy just a guess, Sreddy.... AFAIK there is no such limit in Oracle, and I'm sure there are a lot Oracle databases out there having more than 10.000 users defined....

[sreddy]

You might be Right Jmodic, But, I remembered I read in some documentation its the toal no of concurrent users is 10K.
I will confirm it with my Manager and post it back, he better knows as he deal with Oracle Licencing for products.

[jmodic]

Seek no more.... I've found in "Oracle Reference Manual":

Users and Roles maximum: 2,147,483,638

So we would need about 3 databases to define schema for each and every soul on this planet. Then we'll all be able to fool around in our own Oracle scemas, wouldn't that be nice? :)

[sreddy]

Thanks jmodic. Even I was wondering how can it be just 10K. Seems my memory gone mad, mentioning just 10K with no logical sense...

[edsperez]

Thanks a lot guys!!!

Ed