dbca建库后的目录结构(包括一个CDB,10个PDB):
[root@db-12c tree-1.6.0]# tree /opt/oracle/oradata
/opt/oracle/oradata
`-- cdb
|-- control01.ctl
|-- pdb1
| |-- pdb1_users01.dbf
| |-- sysaux01.dbf
| |-- system01.dbf
| `-- temp01.dbf
|-- pdb10
| |-- pdb10_users01.dbf
| |-- sysaux01.dbf
| |-- system01.dbf
| `-- temp01.dbf
|-- pdb2
| |-- pdb2_users01.dbf
| |-- sysaux01.dbf
| |-- system01.dbf
| `-- temp01.dbf
|-- pdb3
| |-- pdb3_users01.dbf
| |-- sysaux01.dbf
| |-- system01.dbf
| `-- temp01.dbf
|-- pdb4
| |-- pdb4_users01.dbf
| |-- sysaux01.dbf
| |-- system01.dbf
| `-- temp01.dbf
|-- pdb5
| |-- pdb5_users01.dbf
| |-- sysaux01.dbf
| |-- system01.dbf
| `-- temp01.dbf
|-- pdb6
| |-- pdb6_users01.dbf
| |-- sysaux01.dbf
| |-- system01.dbf
| `-- temp01.dbf
|-- pdb7
| |-- pdb7_users01.dbf
| |-- sysaux01.dbf
| |-- system01.dbf
| `-- temp01.dbf
|-- pdb8
| |-- pdb8_users01.dbf
| |-- sysaux01.dbf
| |-- system01.dbf
| `-- temp01.dbf
|-- pdb9
| |-- pdb9_users01.dbf
| |-- sysaux01.dbf
| |-- system01.dbf
| `-- temp01.dbf
|-- pdbseed
| |-- pdbseed_temp01.dbf
| |-- sysaux01.dbf
| `-- system01.dbf
|-- redo01.log
|-- redo02.log
|-- redo03.log
|-- sysaux01.dbf
|-- system01.dbf
|-- temp01.dbf
|-- undotbs01.dbf
`-- users01.dbf
*****************************从seed创建PDB mypdb1:**************************************************
SQL>CREATE PLUGGABLE DATABASE mypdb1 admin user lexidentified by oracle
2 STORAGE (MAXSIZE2G MAX_SHARED_TEMP_SIZE 100M)
3 DEFAULT TABLESPACE lex datafile'/opt/oracle/oradata/cdb/mypdb1/lex.dbf' size 100M
4 PATH_PREFIX ='/opt/oracle/oradata/cdb/mypdb1/'
5 FILE_NAME_CONVERT = ('/opt/oracle/oradata/cdb/pdbseed/','/opt/oracle/oradata/cdb/mypdb1/');
Pluggable databasecreated.
[root@db-12c tree-1.6.0]# tree /opt/oracle/oradata
/opt/oracle/oradata
`-- cdb
|-- control01.ctl
|-- mypdb1
| |-- lex.dbf
| |-- pdbseed_temp01.dbf