1.关闭non-CDB数据库并重启至只读状态，再对non-CDB数据库创建一个xml文件

SQL> shutdown immediate;
SQL> startup open read only;
SQL> exec dbms_pdb.describe(pdb_descr_file=>'/home/oracle/orcl.xml');
SQL> shutdown immediate;

[oracle@mesuat01:/home/oracle]$ lsnrctl stop

2.在另一个终端执行命令

su  - oracle
export ORACLE_SID=orcl1
sqlplus / as sysdba

sys@ORCL1 14-OCT-22> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/product/19.3.0/db/dbs/arch
Oldest online log sequence     4
Next log sequence to archive   6
Current log sequence           6


sys@ORCL1 14-OCT-22> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO


sys@ORCL1 14-OCT-22> create pluggable database orcl using '/home/oracle/orcl.xml' nocopy tempfile reuse;

Pluggable database created.

sys@ORCL1 14-OCT-22> select file_name from cdb_data_files a,cdb_pdbs b where a.con_id=b.con_id and b.pdb_name='ORCL';

no rows selected

Elapsed: 00:00:00.04
sys@ORCL1 14-OCT-22> select name from v$datafile a,cdb_pdbs b where a.con_id=b.con_id and b.pdb_name='ORCL';

NAME
--------------------------------------------------------------------------------
/oradata/ORCL/system01.dbf
/oradata/ORCL/sysaux01.dbf
/oradata/ORCL/undotbs01.dbf
/oradata/ORCL/users01.dbf
/oradata/ORCL/datafile/o1_mf_apprptfa_kndy2w54_.dbf
/oradata/ORCL/datafile/o1_mf_apprptmi_knhkmlgx_.dbf

6 rows selected.

Elapsed: 00:00:00.01
sys@ORCL1 14-OCT-22> alter pluggable database ORCL open;

Warning: PDB altered with errors.

Elapsed: 00:00:00.80
sys@ORCL1 14-OCT-22> alter session set container=ORCL;

Session altered.

Elapsed: 00:00:00.04
sys@ORCL1 14-OCT-22> shutdown immediate;
Pluggable Database closed.
sys@ORCL1 14-OCT-22> @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql


sys@ORCL1 14-OCT-22> startup
Pluggable Database opened.


sys@ORCL1 14-OCT-22> select owner,table_name from all_tables where table_name='T1';

sys@ORCL1 13:48:19> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCL                           READ WRITE NO

sys@ORCL1 13:59:56> create pluggable database PDB01 admin user pdbadmin identified by wwwwww FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/ORCL1/pdbseed', '/oradata/ORCL/PDB01/');

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle