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