Shulou(Shulou.com)05/31 Report--

This article is about how to use FILE_NAME_CONVERT to create a pdb error ORA-01276 in Oracle 12c. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The following ORA-01276 error was encountered when creating a PDB using 12c multi-tenant mode:

SQL > select * from v$version BANNER CON_ID -Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit Production 0PL/SQL Release 12.2.0.1.0-Production 0CORE 12.2.0.1.0 Production 0TNS for Linux: Version 12.2.0.1.0-Production 0NLSRTL Version 12.2.0.1.0-Production 0SQL > create pluggable database yhem from pdb1 2 file_name_convert= ('/ u01apapax oracleqoradata3F605C8D8A4206B6E0536838A8C04ACF' '/ u01 apprenticeship oraclescarporadataUniplicorCLUnitionenmotech') Create pluggable database yhem from pdb1*ERROR at line 1:ORA-01276: Cannot add file/u01/app/oracle/oradata/ORCL/enmotech/datafile/o1_mf_system_d0n37tyk_.dbf.File has an Oracle Managed Files file name.

This error is due to the mapping relationship of the specified directory transformation that is not allowed to be displayed after using the OMF management mode.

You can perform PDB Clone creation by setting the DB_CREATE_FILE_DEST parameter to point to the new PDB directory.

SQL > alter system set db_create_file_dest='/u01/app/oracle/oradata/ORCL/enmotech';System altered.SQL > create pluggable database yhem from pdb1; Pluggable database created.SQL > select name from v$datafile where con_id=5 NAME-/u01/app/oracle/oradata/ORCL/ Enmotech/PG1/428AB277A7FC3DE6E0530381250AFAB1/datafile/o1_mf_system_d3ybm4z6_.dbf/u01/app/oracle/oradata/ORCL/enmotech/PG1/428AB277A7FC3DE6E0530381250AFAB1/datafile/o1_mf_sysaux_d3ybm50s_.dbf/u01/app/oracle/oradata/ORCL/enmotech/PG1/428AB277A7FC3DE6E0530381250AFAB1/datafile/o1_mf_undotbs1_d3ybm50w_.dbf/u01/app/oracle/oradata/ORCL/enmotech/PG1/428AB277A7FC3DE6E0530381250AFAB1/datafile/o1_mf_users_d3ybm50y_.dbfSQL > alter pluggable database yhem open Pluggable database altered.SQL > alter session set container=YHEM;Session altered.SQL > alter session set current_schema=EYGLE;Session altered.SQL > select count (*) from enmotech; COUNT (*)-10 Thank you for reading! On "Oracle 12c using FILE_NAME_CONVERT to create pdb error ORA-01276 how to do" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.