The reference manual has the answer (database limits -- logical limits) Users and Roles Maximum 2,147,483,638 Cheers Stefan ========================= Stefan P Knecht CEO & Founder s@xxxxxxxx 10046 Consulting GmbH Schwarzackerstrasse 29 CH-8304 Wallisellen Switzerland Phone +41-(0)8400-10046 Cell +41 (0) 79 571 36 27 info@xxxxxxxx http://www.10046.ch ========================= On Mon, Oct 12, 2009 at 8:53 PM, Thomas Roach <troach@xxxxxxxxx> wrote: > Hi, > > I have a question. Is there a limit to the number of schemas that an > Oracle database can have? I did some searching but Google did not show > much :)... > > This is 10.2.0.4 but could easily be 11.2. > > Thanks! > > Tom > -- > //www.freelists.org/webpage/oracle-l > > >