conn /assysdba;//切换到根容器创建orclpdb3,从本地的orclpdb2上克隆,不需要从异地主机复制文件create pluggable database orclpdb3fromorclpdb2 file_name_convert=('/u01/app/oracle/oradata/ORCLCDB/orclpdb2','/u01/app/oracle/oradata/ORCLCDB/orclpdb3') ; alter pluggable database orclpdb3 open; ...
示例:(这里只演示使用create pluggable database命令方式创建PDB) 使用CDB seed创建PDB 1.在SQL*Plus中输入CREATE PLUGGABLE DATABASE语句 (这里创建未ypdb1的pdb,管理用户为ypdb1) 代码语言:javascript 代码运行次数:0 运行 AI代码解释 CREATEPLUGGABLEDATABASEypdb1ADMINUSERypdb1IDENTIFIEDBYoracleSTORAGE(MAXSIZE2G)DEF...
Database link created.3.使用CREATEPLUGGABLE DATABASE创建PDBSQL>CREATEPLUGGABLE DATABASE pdbnewFROMpdbsource@clone_pdbsource_pdbnew2FILE_NAME_CONVERT=('/u01/app/oracle/oradata/TESTCDB/pdbsource','/u01/app/oracle/oradata/TESTCDB/pdbnew')3REFRESH MODE MANUAL; Pluggable database created.4.查看系统...
Create a pluggable database from PDB$SEED or from an XML metadata file accessible to the database instance. The use of Oracle Transparent Data Encryption is only supported in topologies where the database and Oracle REST Data Services are on the same host. This service requires db.cdb.admi...
created.2）进行子集克隆，只克隆ts1表空间SYS@ora19c>CREATE PLUGGABLE DATABASE pdb1_z FROM pdb1 file_name_convert=('pdb1','pdb1_z') user_tablespaces=('ts1');Pluggable database created.3）打开新创建的PDB进行验证SYS@ora19c>alter pluggable database pdb1_z open;Pluggable database altered....
create pluggable database pdb1 admin user pdb1 identified by pdb1 file_name_convert=('/u01/app/oracle/oradata/orcl/pdbseed/','/u01/app/oracle/oradata/orcl/pdb1/'); 启动一个创建好的PDB:alter pluggable database pdb1 open; 切换使用一个启动了的PDB: alter session set container=pdb1; ...
2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO SYS@ora19c>create pluggable database pdb2 from pdb1 file_name_convert=('pdb1','pdb2'); Pluggable database created. SYS@ora19c>show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED --- --- --- --- 2 PDB$SEED READ ONLY NO 3 PDB1 ...
CREATE PLUGGABLE DATABASE orclpdb2 ADMIN USER pdb2adm IDENTIFIED BY password ROLES=(DBA) FILE_NAME_CONVERT = ('/opt/oracle/oradata/ORCLCDB/pdbseed/', '/opt/oracle/oradata/ORCLCDB/ORCLPDB2/'); 1. 2. 如果PDB想使用不同的字符集,根容器必须使用AL32UTF8字符集。要更改PDB字符集,必须以RESTRI...
WRITENOSYS@ora19c>create pluggable database pdb2 from pdb1 file_name_convert=('pdb1','pdb2');Pluggable database created.SYS@ora19c>show pdbs;CON_IDCON_NAMEOPENMODERESTRICTED---2PDB$SEEDREADONLYNO3PDB1READWRITENO4PDB2MOUNTED ③ 打开新创建的PDB进行验证 代码语言:javascript 复制 SYS@ora19c...
SQL> CREATE PLUGGABLE DATABASE yunh FROM enmo; Pluggable database created. SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE --- --- PDB$SEED READ ONLY ENMO READ ONLY YUNH MOUNTED 随后可以打开这个新创建的PDB: SQL> ALTER PLUGGABLE DATA...