Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Maximum number of users

Re: Maximum number of users

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Wed, 28 Jan 2004 20:47:30 +0800
Message-ID: <4017AF62.14BB@yahoo.co.uk>


Ralf Zwanziger wrote:
>
> 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

I've seen posts here by people with around 50,000 so you won't be hitting a limit in this respect.

hth
connor

-- 
-------------------------------
Connor McDonald
http://www.oracledba.co.uk
Co-Author: "Mastering Oracle PL/SQL - Practical Solutions"
Received on Wed Jan 28 2004 - 06:47:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US