Re: Databases, Instances, and confusion

From: Jacques Desmazieres <jacques.desmazieres_at_is2france.com>
Date: 2000/06/27
Message-ID: <Zs365.6584$J94.21527567@nnrp2.proxad.net>#1/1

Rather than running a new instance, you may want to create a new schema (CREATE USER. Jacques

"Matthew Ivaliotes" <lotus_at_uiuc.edu> wrote in message news:SQ265.856$Il3.18686_at_vixen.cso.uiuc.edu...
> We're in the process of planning a migration to Oracle from Sybase. I'll
> be taking the DBA-level training soon, but until then I'm 'fiddling' with
> Oracle when I can to get a feel for it. I've noticed that when I create a
> second database, Oracle starts up a second instance of itself in memory.
> This isn't how things worked in the Sybase world. Have I done something
> wrong? Each instance of Oracle is chewing up a couple hundred MB of RAM.
> Rather than have to have aqn instance going for each DB, do I simply need
> to have more tables in each DB?
>
> Thanks,
>
> Matt I.
> speaking only for myself
Received on Tue Jun 27 2000 - 00:00:00 CDT