Oracle 12c pdbseed Tips

SYS@PRODCDB1> show pdbs

	CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
		 2 PDB$SEED                       READ ONLY  NO
		 3 PDB1                           READ WRITE NO
SYS@PRODCDB1> alter session set "_oracle_script"=true;

Session altered.

SYS@PRODCDB1> alter pluggable database pdb$seed close immediate;

Pluggable database altered.

SYS@PRODCDB1> show pdbs

	CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
		 2 PDB$SEED                       MOUNTED
		 3 PDB1                           READ WRITE NO
SYS@PRODCDB1> alter pluggable database pdb$seed open;

Pluggable database altered.
SYS@PRODCDB1> show pdbs;

	CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
		 2 PDB$SEED                       READ WRITE NO
		 3 PDB1                           READ WRITE NO
SYS@PRODCDB1> 
SYS@PRODCDB1> create table tab01 (col1 varchar2(10));

Table created.

SYS@PRODCDB1> insert into tab01 values('aaaa');

1 row created.

SYS@PRODCDB1> commit;

Commit complete.

SYS@PRODCDB1> select * from tab01;

COL1
----------
aaaa

SYS@PRODCDB1> 
SYS@PRODCDB1> alter pluggable database pdb$seed close immediate;

Pluggable database altered.

SYS@PRODCDB1> 
SYS@PRODCDB1> alter pluggable database pdb$seed open read only;

Pluggable database altered.

SYS@PRODCDB1>