ORACLE12C: Create a new user and its default tablespace after installation and make a table test

• Environment:

Operating system: Windows Server2008 R2 X64

Oracle version: 12c

How do I install it?

--Oracle 12c installation on Oracle Linux 6.6 x64

--Perfect installation under Windows x64 bit winx64_oracle_12c_database

How do I use database cofiguration Assistant to create databases?

--oracle12c DBCA way to create a DB instance (multi-image)

How do i use PL/SQL developer connection?

--PL/SQL developer connected to Oracle 12c

Note: The top PL/SQL developer Connection Oracl 12c Way, I did not succeed.

Initial installation of oracle12c, found with the previous use of the oracle9g version is still a bit different.

• The information obtained from the official website is the new concept of oracle12c:

1,oracle12c added the concept of pluggable databases, the concept of PDB, which allows a database container (CDB) to host multiple pluggable databases (PDB).

CDB Full name container database, Chinese translation as a data base container;

PDB full name pluggable database, Chinese translation into pluggable databases.

2 . Before oracle12c, the instance and data are one-to-one or many-to-a relationships (RAC): That is, a data instance can only be associated with one database, and the database may be loaded by multiple instances.

However, an instance cannot be a one-to-many relationship with a database.

3, after entering the oracle12c, the instance and the database can be a one-to-many relationship.

is the official website provides the CDB and the PDB diagram:

What are the benefits of the new concept above?

The PDB does bring a lot of benefits to the programmer: But it also brings some differences to administrators.

First, when a container database creates a new user and allocates a tablespace, it can be done in the following two scenarios:

1, must be in the absence of the PDB, the case;

2, the PDB and CDB have the same table space case.

Otherwise, it will fail.

If the PDB and CDB have the same table space to allocate table space to the CDB user, the table space of the CDB is allocated to the user, and the PDB tablespace is not affected;

Also, CDB users must start with ' c## ' or create a user failure.

Reference:

Oracle 12c Database CDB user creation and table space allocation issues

Oracle Official documents: http://docs.oracle.com/database/121/index.htm

The CDB, PDB, Pdb$seed, and SQL Server objects correspond to:

• 1, CDB and PDB can implement a CDB corresponding to multiple PDB, which corresponds to a single instance of SQL Server multiple database schema is a little similar idea.
• 2, Pdb$seed can be regarded as the master, msdb and other system database;
• 3, PDBs can be regarded as user-created database.
• 4, pluggable concept and SQL Server in the user database separation, attach a similar idea.

CDB Database Components:

1. Root component

ROOT is also known as Cdb$root, which stores the metadata provided by Oracle and the Common user, an example of which is the source code for the PL/SQL package provided by Oracle, Common user refers to the users that exist in each container.

2. Seed Components

Seed is also called pdb$seed, this is the template you created for the PDBs database, and you cannot add or modify an object in seed. There is only one seed in a CDB. This is similar to the model database in SQL Server.

3, PDBs

CDB can have one or more Pdbs,pdbs backwards compatible, and can operate PDBs as before in the database, where only the majority of operations.

Each of these components can be called a container. Therefore, root (root) is a container, and seed (seed) is a container, and each PDB is a container. Each container has a unique ID and name in the CDB.

Reference: ORACLE 12C new features--CDB and PDB

• Create a new user, assign a default tablespace, assign permissions

ORACLE12C: Create a new user and its default tablespace after installation and make a table test