Re: Creating schema in oracle10g express edition

hpuxrac wrote:
> Well then on the sql server side you have 50 separate databases to
> manage? Each with it's own set of transaction logs right?
Actually I think SQL Server 2005 introduced more complete schema support.

> To me anway the oracle side makes more sense.
> You don't often create 50 separate schema's in oracle to host the
> tables for a set of application. Usually you have a couple of schemas
> and you keep adding additional tables to the important schemas.
.. but you may have a lot of PACKAGES in these two schemas..? I suspect that may be where the mapping between the DBMS falls apart. DB2 and SQL server 2005 use schemata to group objects. users are loosely connected to schemas (like login and home directory tend to be loosely connected)
Oracle developers group objects (except for tables) in packages.

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html