建立表空间及用户相关

-- select * from dba_data_files;--/data2/oracle/oradata/dw_supv03.dbf
--删除用户
-- drop user EPORT cascade;
--创建表空间
create tablespace EPORT DATAFILE '/data2/oracle/oradata/EPORT01.dbf' size 100M 
AUTOEXTEND ON NEXT 5M MAXSIZE unlimited
extent management local autoallocate segment space management auto;
--添加数据文件
alter tablespace EPORT add datafile '/data2/oracle/oradata/EPORT02.dbf' size 100M autoextend on next 5M maxsize unlimited;
--添加数据文件
alter tablespace EPORT add datafile '/data2/oracle/oradata/EPORT03.dbf' size 100M autoextend on next 5M maxsize unlimited;
​
-- 创建用户
CREATE USER EPORT IDENTIFIED BY EPORT DEFAULT TABLESPACE EPORT;
-- 授予空间限额
ALTER USER EPORT QUOTA UNLIMITED ON EPORT;
-- 使其可连接数据库
GRANT CONNECT, RESOURCE TO EPORT;
-- 授予此用户在所有用户所有表的 select 权限
GRANT SELECT ANY TABLE TO EPORT;
-- GRANT CREATE ANY VIEW TO EPORT;