首页 > 代码库 > Oracle 12c 建表空间语句
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 DATABASEBEGIN EXECUTE IMMEDIATE ‘alter pluggable database all open‘;END open_all_pdbs;/alter pluggable database pdbmyoracle open;alter session set container = pdbmyoraclealter session set container = CDB$ROOT;
Oracle 12c 建表空间语句
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。