12c创建为容器数据库_详谈Oracle12c新特点容器数据库&可插拔数据库（CDB&PDB）

数据字典

CDB_FILE$

DBA_PDBS

PDB$SEED

CDB_LOCAL_ADMINAUTH$

DBA_PDB_HISTORY

PDB_HISTORY$

CDB_PDB_SAVED_STATES

DBA_PDB_SAVED_STATES

PDB_PLUG_IN_VIOLATIONS

CDB_RESOURCE_PLAN$

DBMS_PDB

PDB_SPFILE$

CDB_RESOURCE_PLAN_DIRECTIVE$

DBMS_PDB_EXEC_SQL

V$CONTAINERS

CDB_SERVICE$

GV$CONTAINERS

V$PDBS

CDB_HIST_PDB_INSTANCE

GV$PDBS

V$PDB_INCARNATION

CDB_PDBS

GV$PDB_INCARNATION

WRI$_ADV_ADDM_PDBS

CDB_PDB_HISTORY

GV$SESSIONS_COUNT

WRM$_PDB_INSTANCE

INT$DBA_PDB_SAVED_STATES

XDB$CDBPORTS

DBA_HIST_PDB_INSTANCE

PDB_ALERT$

角色

CDB_DBA

系统权限

CREATE PLUGGABLE

DATABASE

SET CONTAINER

SET CONTAINER

探究SEED PDB

从PDB$SEED创建PDB

语法：

CREATE PLUGGABLE

DATABASE

ADMIN

USER IDENTIFIED BY

FILE_NAME_CONVERT = ('',

'')

ROLES = ()

DEFAULT

TABLESPACE [DATAFILE ]

EXTENT MANAGEMENT

LOCAL

STORAGE ];

例子：

col con_name format

a10

col restricted format

a10

SELECT v.name, v.open_mode,

v.restricted, d.status

FROM v$pdbs v, dba_pdbs

d

WHERE v.guid =

d.guid

ORDER BY

v.create_scn;

NAME OPEN_MODE RESTRICTED STATUS

------------------------------

---------- ---------- -------------

PDB$SEED READ ONLY NO NORMAL

ALTER PLUGGABLE DATABASE pdb1

OPEN;

SELECT v.name, v.open_mode,

v.restricted, d.status

FROM v$pdbs v, dba_pdbs

d

WHERE v.guid =

d.guid

ORDER BY

v.create_scn;

NAME OPEN_MODE RESTRICTED STATUS

------------------------------

---------- ---------- -------------

PDB$SEED READ ONLY NO NORMAL

SELECT * FROM

dba_pdbs;

-- 12.1.0.1 version

-- SELECT * FROM

cdb$view(dba_pdbs);

-- 12.1.0.2 versionSELECT *

FROM containers(dba_pdbs);

-- 12.1.0.1 version

-- SELECT * FROM

cdb$view(cdb_pdbs);

-- 12.1.0.2 version

SELECT * FROM

containers(cdb_pdbs);

SELECT table_name,

tablespace_name, con_id

FROM

containers(dba_tables)

WHERE rownum <

6;

CREATE PLUGGABLE

DATABASE pdb1

ADMIN

USER TEST IDENTIFIED

BY TEST

FILE_NAME_CONVERT =

('/pdbseed/', '/pdb1/');

SELECT v.name, v.open_mode,

NVL(v.restricted, 'n/a') RESTRICTED, d.status

FROM v$pdbs v, dba_pdbs

d