2019. 6. 18. 17:06 오라클
Oracle PDB rename
- Oracle PDB rename 테스트 (12.2.0.1)
pdb1 -> pdb2 로 이름변경
1. 해당 pdb close
SQL> alter pluggable database pdb1 close immediate;
2. restricted mode 로 open
SQL> alter pluggable database pdb1 open restricted;
SQL> select name, restricted from v$pdbs;
3. 해당 pdb 접속
SQL> alter session set container=pdb1;
SQL> alter pluggable database pdb1 rename global_name to pdb2;
4. pdb close
SQL> alter pluggable database close immediate;
5. pdb open
SQL> alter pluggable database open;
SQL> select name, open_mode from v$pdbs;
