19c pdb 新建
【摘要】 OMF方式管理数据文件 The PDB shares the same base file system directory for Oracle Managed Files with the root and has its own subdirectory named with the GUID of the PDB.alter session set db_create_file_de...
OMF方式管理数据文件
The PDB shares the same base file system directory for Oracle Managed Files with the root and has its own subdirectory named with the GUID of the PDB.
alter session set db_create_file_dest='/data';
CREATE PLUGGABLE DATABASE pdb001 ADMIN USER admin IDENTIFIED BY admin;
如果未指定参数,报错信息:
SQL> CREATE PLUGGABLE DATABASE pdb001 ADMIN USER admin IDENTIFIED BY admin;
CREATE PLUGGABLE DATABASE pdb001 ADMIN USER admin IDENTIFIED BY admin
*
ERROR at line 1:
ORA-65016: FILE_NAME_CONVERT must be specified
pdb_file_name_conver
//注意这里 pdb_file_name_convert 参数生效级别设置的是 session
//设置了db_create_file_dest参数,该参数默认不生效。
alter session set pdb_file_name_convert='pdb01','pdb02';
create pluggable database pdb02 from pdb01;
如果未指定参数,报错信息:
SQL> create pluggable database pdb02 from pdb01;
create pluggable database pdb02 from pdb01 *
ERROR at line 1:
ORA-65016: FILE_NAME_CONVERT must be specified
FILE_NAME_CONVERT
//该参数进行物理位置名称替换,忽略db_create_file_dest参数。
//未设置改参数,默认使用OMF,未设置OMF,使用DB_FILE_NAME_CONVERT参数。
If you omit this clause, then the database first attempts to use Oracle Managed Files to generate file names. If you are not using Oracle Managed Files, then the database uses thePDB_FILE_NAME_CONVERT
initialization parameter to generate file names. If this parameter is not set, then an error occurs.
CREATE PLUGGABLE DATABASE pdb03 from pdb01
FILE_NAME_CONVERT = ('pdb01', 'pdb03');
插
【声明】本内容来自华为云开发者社区博主,不代表华为云及华为云开发者社区的观点和立场。转载时必须标注文章的来源(华为云社区)、文章链接、文章作者等基本信息,否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱:
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论(0)