19c pdb 新建

举报
snowofsummer 发表于 2021/06/01 07:27:09 2021/06/01
2k+ 0 0
【摘要】 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 the PDB_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

抱歉,系统识别当前为高风险访问,暂不支持该操作

    全部回复

    上滑加载中

    设置昵称

    在此一键设置昵称,即可参与社区互动!

    *长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。

    *长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。