It's more complicated than that. Roles and other database entity types make up the total limit: http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/limits003.htm#i288032 ----- Original Message ----- From: "Thomas Roach" <troach@xxxxxxxxx> To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx> Sent: Monday, October 12, 2009 1:53:35 PM GMT -06:00 US/Canada Central Subject: Oracle Schema Limitation? 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 -- Michael Fontana Sr. Technical Consultant Enkitec M: 214.912.3709 enkitec oracle_certified_partner -- //www.freelists.org/webpage/oracle-l