参考博客

查看所有用户

SELECT * FROM DBA_USERS

创建用户

# 创建一个“emdata_admin”的用户
create user EMDATA_ADMIN identified BY 123456

创建表空间

create tablespace EMDATA_ADMIN 
datafile 'E:\\oracle_tablespaces\\DEMOSPACE_TBSPACE.dbf' 
size 1500M 
autoextend on next 5M maxsize 3000M;#赋予表空间权限
grant dba,resource,connect to EMDATA_CX;
grant create tablespace to EMDATA_CX;

查看表空间

select * from dba_tablespaces;