Multiple applications and Tablespaces
294379Jul 8 2009 — edited Jul 8 2009Hi All,
I am currently an SQL Server DBA and Admin but I'm currently trying to learn a little more about how Oracle does its thing. As such, could someone help me with the following:
In SQL Server we might have up to 70 -> 80 "Databases" attached to a single database "Instance". Each database could be for a particular application we are developing for one of our clients, or it could even be for a specific internal system.
I know Oracle has a different definition of what a "Database" is so I'm wondering if someone could give some guidance on how I would create my 70 or 80 databases under Oracle (if I were so inclined).
The nearest analogue I can see in Oracle would perhaps be Tablespaces, but that doesn't seem like a perfect fit either. Is it even possible or common to have several database applications running under one instance of Oracle, or is Oracle perhaps just meant for single uber applications?
Many thanks to anyone who can help
Best Regards
Simon