RE: Databases, Instances, and confusion

Yes Oracle create a SGA for each database (instance). You could make another user (schema) and create the tables into this user schema...
Then you can refer to it in the form: USER.TABLE

                                        luck

Matthew Ivaliotes <lotus_at_uiuc.edu> escribió en el mensaje de noticias 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