Re: Oracle Schema Limitation?

From: Michael Fontana <michael.fontana_at_enkitec.com>
Date: Mon, 12 Oct 2009 15:30:13 -0500 (CDT)
Message-ID: <10946668.9011255379413942.JavaMail.root_at_mail.enkitec.com>

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_at_gmail.com> To: "Oracle Discussion List" <oracle-l_at_freelists.org> 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
--

http://www.freelists.org/webpage/oracle-l

--

Michael Fontana

Sr. Technical Consultant

Enkitec M: 214.912.3709

enkitec

oracle_certified_partner

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 12 2009 - 15:30:13 CDT