Re: Maximum number of users

Giganews Newsgroups
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
news:fi9f10d5mapo2p34l9jmedak5agf4hoh…@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

Replies

In response to

Maximum number of users posted by Ralf Zwanziger on Wed, 28 Jan 2004