oracle 12c pdbseed tips

[email protected]> show pdbs

	CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
		 2 PDB$SEED                       READ ONLY  NO
		 3 PDB1                           READ WRITE NO
[email protected]> alter session set "_oracle_script"=true;

Session altered.

[email protected]> alter pluggable database pdb$seed close immediate;

Pluggable database altered.

[email protected]> show pdbs

	CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
		 2 PDB$SEED                       MOUNTED
		 3 PDB1                           READ WRITE NO
[email protected]> alter pluggable database pdb$seed open;

Pluggable database altered.
[email protected]> show pdbs;

	CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
		 2 PDB$SEED                       READ WRITE NO
		 3 PDB1                           READ WRITE NO
[email protected]> 
[email protected]> create table tab01 (col1 varchar2(10));

Table created.

[email protected]> insert into tab01 values('aaaa');

1 row created.

[email protected]> commit;

Commit complete.

[email protected]> select * from tab01;

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

[email protected]> 
[email protected]> alter pluggable database pdb$seed close immediate;

Pluggable database altered.

[email protected]> 
[email protected]> alter pluggable database pdb$seed open read only;

Pluggable database altered.

[email protected]>