abce - 博客园

Oracle 12C -- 不同容器之间切换

2015-11-01 15:44 by abce, 1306 阅读, 0 推荐, 收藏,

摘要：1.使用connect 2.使用alter session 阅读全文

0 Comment

Oracle 12C -- 删除PDB

2015-10-31 14:59 by abce, 2731 阅读, 0 推荐, 收藏,

摘要：删除PDB SQL> select con_id,pdb_name,status from cdb_pdbs; CON_ID PDB_NAME STATUS ---------- ------------------------------ ---------... 阅读全文

0 Comment

Oracle 12C -- plug unplugged PDB into CDB

2015-10-31 14:46 by abce, 839 阅读, 0 推荐, 收藏,

摘要：connetct to CDB as a common user and verify that pdb_test is closed A PDB must be dropped from the CDB before it can be plugged back into the same CDB 阅读全文

0 Comment

Oracle 12C -- clone a remote pdb

2015-10-31 13:52 by abce, 680 阅读, 0 推荐, 收藏,

摘要：Connect to the remote CDB and prepare the remote PDB for cloning. Create a user in the remote database for use with the database link. In this case, w 阅读全文

0 Comment

Oracle 12C -- clone a non-cdb as a pdb

2015-10-31 12:43 by abce, 614 阅读, 0 推荐, 收藏,

摘要：将non-CDB置为只读模式：连接到CDB，创建一个DBLINK，连接到non-cdb：克隆non-cdb，并执行脚本：打开克隆好的数据库：阅读全文

0 Comment

Oracle 12C -- 使用local PDB克隆新的PDB

2015-10-30 17:08 by abce, 684 阅读, 0 推荐, 收藏,

摘要：1.将用于克隆的PDB至于只读状态：startup open read only 2.登陆CDB 3.打开原来的PDB 阅读全文

0 Comment

Oracle 12C -- Plug in a Non-CDB as a PDB

2015-10-30 16:45 by abce, 349 阅读, 0 推荐, 收藏,

摘要：1.备份non-CDB数据库2.关闭non-CDB数据库 3.将non-CDB至于只读状态 4.创建一个XML文件(在non-CDB中创建) 这里创建的xml文件和原库的数据文件组成了一个unplugged PDB 5.关闭non-CDB数据库6.登陆CDB 阅读全文

0 Comment

ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged

2015-10-30 14:45 by abce, 2925 阅读, 0 推荐, 收藏,

摘要：SQL> drop pluggable database pdb2; drop pluggable database pdb2 * ERROR at line 1: ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged SQL> drop pluggable database pdb2 ... 阅读全文