Oracle 12c 建表空间语句

create tablespace TBS_DYS datafile  D:/Oracle_12c/app/dingyingsi/oradata/dingyingsi/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/dingyingsi/oradata/dingyingsi/TBS_DYS_TEMP.ba SIZE 600M     autoextend on       next 32m       maxsize 2048m extent management local;
 
CREATE USER dingyingsi IDENTIFIED BY Dingyingsi1988 DEFAULT TABLESPACE TBS_DYS TEMPORARY TABLESPACE TBS_DYS_TEMP ACCOUNT 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;

Drop tablespace TBS_DYS;
Drop tablespace TBS_DYS_TEMP;

CREATE TRIGGER open_all_pdbs
   AFTER STARTUP
   ON DATABASE
BEGIN
   EXECUTE IMMEDIATE alter pluggable database all open;
END open_all_pdbs;
/

alter pluggable database pdbmyoracle open;

alter session set container = pdbmyoracle

alter session set container = CDB$ROOT;

 

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。