Re: Adding Second Database in oracle 10g

Bob Jones wrote:

> Are you trying to add a second database to the same instance? It will not
> work in Oracle. Unlike most other databases, it is one database per instance
> in Oracle. So add a new instance before creating the database.

Likely this person is from Ingres related background (Informix, Sybase, SQL Server) and is referring to a schema.

But in Oracle it is NOT a 1:1 relationship. It is a Many:1 relationship. Or or more instances can connect to one database.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)