Skip to content

Instantly share code, notes, and snippets.

@DarkAngelStrike
Last active May 8, 2017 03:08
Show Gist options
  • Save DarkAngelStrike/6ad00659b759d5f15c6571054f4374d6 to your computer and use it in GitHub Desktop.
Save DarkAngelStrike/6ad00659b759d5f15c6571054f4374d6 to your computer and use it in GitHub Desktop.
[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