1、从PDB$SEED创建新PDB
|
1
2 |
SQL>
create
pluggable
database
PDB3 admin
user
pdb3admin identified
by
oraclefile_name_convert=(
'/u01/oradata/cdb1/pdbseed'
,
'/u01/oradata/cdb1/pdb3'
) ; |
2、克隆本地PDB
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14 |
SQL> show pdbs
CON_ID CON_NAME
OPEN
MODE RESTRICTED---------- ------------------------------ ---------- ----------
2 PDB$SEED
READ
ONLY
NO
3 PDB1
READ
WRITE
NO
4 PDB2 MOUNTED
6 PDB3 MOUNTEDSQL>
alter
pluggable
database
pdb1
close
;插接式数据库已变更。SQL>
alter
pluggable
database
pdb1
open
read
only
;插接式数据库已变更。SQL>
create
pluggable
database
pdb4
from
pdb1 file_name_convert=(
'/u01/oradata/cdb1/pdb1'
,
'/u01/oradata/cdb1/pdb4'
) ;插接式数据库已创建。SQL> |