Question: Database vs TableSpace (please help)

In MS SQL Server, we used the service manager (database manager in Oracle) to startup the server and then all databases on that server would be accessible. On Oracle, it seems that you startup a specific database. So if we have multiple databases on a server, do we start all of them individually? Following is an example...

We have two projects going, X and Y. Both are unrelated and need there own databases. Under MS SQL Server, we went into Enterprise Manager and simply created two DB's (as simple as right clicking and choosing a menu item). Then we only started the server and all of the DB's on it were accessible. On ORACLE, I think things work different way. Is TABLE SPACE equivalent to "databases" on SQL Server? In our example, are we better off creating two DATABSES on the Oracle server and startup both individually or create two TABLE SPACES, one for X and one for Y, under the same database (e.g. default ORCL database). If later is the case (i.e. using table spaces), does Oracle complain about having exact same table names under two different table spaces in the same database? How do we resolve conflicts? We looked at the documentation and and it seems that creating a database is quite long and complex process.

WHAT IS THE BEST WAY TO GO??? Thanks very much.

Regards,
Nasir (nnoor_at_cris.com) Received on Fri Mar 21 1997 - 00:00:00 CST