obsidian/04-技术笔记/数据库/Oracle/Oracle创建PDB.md

#创建PDB储存文件 注意请在root用户状态下创建，必须给oracle用户对应权限

==#====创建存储文件，====注意必须和下方的匹配==
mkdir -p /u01/app/oracle/oradata/CDB/mypdb
chown -R oracle:oinstall /u01/app/oracle/oradata/CDB/mypdb
chmod -R 775 /u01/app/oracle/oradata/CDB/mypdb

#创建种子文件
mkdir -p /u01/app/oracle/oradata/CDB/pdbseed
chown -R oracle:oinstall /u01/app/oracle/oradata/CDB/pdbseed
chmod -R 775 /u01/app/oracle/oradata/CDB/pdbseed

==#====/u01/app/oracle/oradata/CDB/mypdb====这个是新的====PDB====文件==
==#====/opt/oracle/oradata/ORCLCDB/pdbseed== ==这个是种子模板文件==
CREATE PLUGGABLE DATABASE mypdb ADMIN USER mypdbadmin IDENTIFIED BY mypdbadminpass FILE_NAME_CONVERT=('==/opt/oracle/oradata/ORCLCDB/pdbseed==','==/u01/app/oracle/oradata/CDB/mypdb==');