Oracle 12c Operation CDB PDB

CREATE TRIGGER Open_all_pdbs after STARTUP on Databasebegin EXECUTE IMMEDIATE ' alter pluggable database all open ';END Open_all_pdbs;/alter Pluggable Database all Openalter pluggable database all close;alter session SET container= Pdbmyoracle;alter session SET container= Cdb$root;Create tablespace tbs_dys datafile ' d:/oracle_12c/app/dys/oradata/dys/tbs_dys.ba ' size 1024m reuse autoextend on Next 100m maxsize UNLIMITED extent management Local;CREATE temporary tablespace tbs_dys_temp tempfile ' d:/oracle_12c/app/dys/oradata/dys//tbs_dys_temp.ba ' SIZE 600M Auto Extend on next 32m maxsize 2048m extent management Local;CREATE USER Dingyingsi identified by Dingyingsi1988 DEFAULT tablespace tbs_dys temporary tablespace tbs_dys_temp ACCO UNT UNLOCK;GRANT CREATE TABLE to Dingyingsi;GRANT UNLIMITED tablespace to Dingyingsi;GRANT CONNECT to Dingyingsi with ADMIN OPTION;GRANT RESOURCE to Dingyingsi with ADMIN OPTION;GRANT DBA to Dingyingsi;