oracle 使用plsql 创建表空间，用户以及分配权限

2019独角兽企业重金招聘Python工程师标准>>>

创建表空间

--创建临时表空间
CREATE TEMPORARY TABLESPACE BGDATA_TEMP TEMPFILE '/data/app/oracle/oradata/orcl/temp02.dbf ' SIZE 512M REUSE AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;

--创建数据表空间
CREATE TABLESPACE BGDATA DATAFILE '/data/app/oracle/oradata/orcl/bg_data.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;

--删除表空间
DROP TABLESPACE BGDATA INCLUDING CONTENTS AND DATAFILES;

创建用户及授权

-- Create the user
-- Create the user
create user bg
  identified by cms2018
  default tablespace BGDATA
  temporary tablespace BGDATA_TEMP;
-- Grant/Revoke role privileges 
grant connect to bg;
grant resource to bg;
grant dba to bg;

转载于:https://my.oschina.net/terwergreen/blog/1859450