创建PDB
SQL> create pluggable database zhixin ADMIN USER zhixin IDENTIFIED BY oracle STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M) DEFAULT TABLESPACE sales DATAFILE '/u01/oracle/oradata/zhixin/zhixin01.dbf' SIZE 250M AUTOEXTEND ON file_name_convert=('/u01/or 2 3 4 5 acle/oradata/ZXKJ_S/datafile/','/u01/oracle/oradata/zhixin/'); create pluggable database zhixin ADMIN USER zhixin IDENTIFIED BY oracle * ERROR at line 1: ORA-01276: Cannot add file /u01/oracle/oradata/zhixin/o1_mf_system_cv6q6vd3_.dbf.File has an Oracle Managed Files file name.
原因:
如果启动OMF(Oracle Managed Files)管理,就不能使用PDB_FILE_NAME_CONVERT 转换参数
如果我们需要修改数据文件存储位置,可以使用DB_CREATE_FILE_DEST 参数
首先创建新的路径
[root@rac2 oradata]# mkdir -p /u01/oracle/oradata/zhixin [root@rac2 oradata]# chown oracle:oinstall /u01/oracle/oradata/zhixin
修改DB_CREATE_FILE_DEST
SQL> alter system set DB_CREATE_FILE_DEST='/u01/oracle/oradata/zhixin'; System altered.
创建PDB
SQL> create pluggable database zhixin ADMIN USER zhixin IDENTIFIED BY oracle STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M) DEFAULT TABLESPACE sales DATAFILE '/u01/oracle/oradata/zhixin/zhixin01.dbf' SIZE 250M AUTOEXTEND ON; Pluggable database created.
查看新的pdb数据文件路径
SQL> select name from v$datafile where name like '%zhixin%'; NAME ------------------------------------------------------------------------------------------------------- /u01/oracle/oradata/zhixin/ZXKJ_S/3B47AA2E94050D76E053B601A8C04D1E/datafile/o1_mf_system_cwbpk05m_.dbf /u01/oracle/oradata/zhixin/ZXKJ_S/3B47AA2E94050D76E053B601A8C04D1E/datafile/o1_mf_sysaux_cwbpk05o_.dbf /u01/oracle/oradata/zhixin/zhixin01.dbf
版权声明:本文为博主原创文章,未经博主允许不得转载。
oracle 12c pdb
- 上一篇:12C 临时UNDO说明
- 下一篇:安装12c oem缺少包