本地克隆创建PDB
创建一个新的PDB from SEED
alter session set container=PDB$SEED; select file_name from dba_data_files; FILE_NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/orcl1/pdbseed/system01.dbf /u01/app/oracle/oradata/orcl1/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/orcl1/pdbseed/undotbs01.dbf conn / as sysdba create pluggable database pdb2 admin user pdb_mgr identified by oracle file_name_convert=('/u01/app/oracle/oradata/orcl1/pdbseed','/u01/app/oracle/oradata/orcl1/pdb2'); alter pluggable database pdb2 open; show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 READ WRITE NO |