Last active
May 8, 2017 03:08
-
-
Save DarkAngelStrike/6ad00659b759d5f15c6571054f4374d6 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[oracle@server ~]$ sqlplus / as sysdba | |
SQL*Plus: Release 12.2.0.1.0 Production on Thu Apr 27 13:40:56 2017 | |
Copyright (c) 1982, 2016, Oracle. All rights reserved. | |
Connected to: | |
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production | |
SYS@CDB> CREATE PLUGGABLE DATABASE PDB USING '/tmp/ORCL.xml' NOCOPY TEMPFILE REUSE; | |
Pluggable database created. | |
SYS@CDB> show pdbs | |
CON_ID CON_NAME OPEN MODE RESTRICTED | |
---------- ------------------------------ ---------- ---------- | |
2 PDB$SEED READ ONLY NO | |
4 PDB MOUNTED | |
SYS@CDB> col pdb_name for a15 | |
SYS@CDB> select pdb_name, status from dba_pdbs where pdb_name = 'PDB'; | |
PDB_NAME STATUS | |
--------------- ---------- | |
PDB NEW | |
SYS@CDB> alter session set container=PDB; | |
Session altered. | |
SYS@CDB> @?/rdbms/admin/noncdb_to_pdb.sql | |
... |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment