|Subject:||Re: Maximum number of users|
|Posted by:||Richard Foote (richard.foo…@bigpond.com)|
|Date:||Thu, 29 Jan 2004|
"Ralf Zwanziger" <goldensurfer-NOSP…@gmx.de> wrote in message
> 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.
You can't exceed 2,147,483,638 users and roles in a database.
Maximum number of users posted by Ralf Zwanziger on Wed, 28 Jan 2004