Home -> Usenet -> comp.databases.oracle -> When to Create Database vs Schema only !!!

When to Create Database vs Schema only !!!

From: bigwave <bigwave_at_primenet.com>
Date: 1996/01/30
Message-ID: <4elblp$m5j_at_nnrp1.news.primenet.com>#1/1 






Question...  I have an option to just generate a schema owned by xxx or an 
entire CREATE DATABASE xxx  ,,,,  what are the reasons for/against the need to 
create a DATABASE.  In other words, what reasons drive the need to create a 
separate Database?  Reduce load on engine, recovery, resource availability ??



I have a stronger background in DB2 mainframe than Oracle and am in transition 
(first year) to Oracle environment.



Bigwave  1-30-96
Received on Tue Jan 30 1996 - 00:00:00 CET












Original text of this message