Creating Multiple Databases

[DQuinn]

Hi,

How do you create multiple databases under the same Oracle
8.1.7 server.

Ex: A baseball stats database and a hockey stats database.

Thanks

[uday]

May be you want to create 2 different schema's under the same database

Here are the definitions of basic stuff in oracle

Instance : The background process and memory structures that do the job

Database : Data files that form the database

Schema : A logical grouping of objects or a user in the database.

In your case, I would create 1 database ( which creates an instance by default) and then create 2 schema's namely baseball and hockey.

Then place all your baseball tables in baseball schema and hockey tables in hockey schema

hope that helps... and for the experts, I was only trying to make the definitions simple, dont flame me on it.

uday

[DQuinn]

Sorry about the confusion.

I meant to say 2 different instances.
Can I run 2 instances on the same computer, or do they have to be on separate machines??

Thanks

[pipo]

of course you can, it will consume 2 SGAs, but it is completely possible