Re: Maximum number of users

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 29 Jan 2004 09:14:30 GMT
Message-ID: <W94Sb.33210$Wa.31559@news-server.bigpond.net.au>

"Ralf Zwanziger" <goldensurfer-NOSPAM_at_gmx.de> wrote in message news:fi9f10d5mapo2p34l9jmedak5agf4hoh6a_at_4ax.com...
> Is there a maximum number of users (created with "create user ..." in
> the database - NOT in OID) in Oracle9i or is the max. number of users
> only limited by system tablespace size?
> The problem: I have to create about 8000 users (per script). OID is
> not an option we have - the application we run is dependant on the
> existance of database users.
> Bye,
> Ralf
>

Hi Ralf,

Yes.

You can't exceed 2,147,483,638 users and roles in a database.

Cheers

Richard Received on Thu Jan 29 2004 - 03:14:30 CST