Mysql, oracle is beginning, take a look at the database, the instance, table space, the relationship between the user,
She has a problem, if there are two completely unrelated projects, all want to establish a database to store data, but it must be on the same server, so should be how to build library?
Mysql, of course, is to build two database and the oracle seems to have several options, as follows:
1. Create two databases, respectively for
2. Use the same database, create two instances to store
3. An instance, built two corresponding table space for
4. A table space to two users, a project corresponding to a user
The above several kinds of all feasible? So help me to recommend, from a security, convenience of management, performance, etc., which is the most reasonable! Under the best reanalysis, thanks.

CodePudding user response:

Suggest the building Lord first to know about the storage architecture of oracle database (database) and memory structure (instance)

4. A table space to two users, a project corresponding to a user

You create two user (schema), each user has its own table space (in TABLESPACE), this store is better, put a table space it doesn't matter;

CodePudding user response:

In fact instance is known as the database

CodePudding user response:

1st floor is said 3, 4 are ok, 3 are sure to have two or more users to manage,
The second floor is between the 2?
Analysis of the reasons bai

CodePudding user response:

A database set up two users, each user (business) for the no table space