I mostly use SQL Server, but lately have been experimenting with Oracle XE. There are some questions I have regarding how data is logically separated within Oracle. Please excuse me if I need to refer to SQL Server to put these questions in context.
It seems Oracle XE only comes with one database installed. You cannot create a new one. After reading some of the documentation about how Oracle stores data, it seems that an Oracle server does not store information in the same way SQL Server does. That is, there is no concept of separate databases on a server. Im guessing that the Oracle equivalent is Tablespaces. There is a oracle tablespace called USERS that it seems I should be putting all the data I need. My question is, how do I logically distinguish what I used to consider separate databases in SQL Server. In SQL Server, these databases had different owners, and were administered separate from one another. As well, any application that connected to a specific database, could only see that database?
Could someone put this into context for me?