oracle创建用户和表空间

1.查询当前用户和数据文件路径

select * from dba_users;
select * from DBA_DATA_FILES;
2.查询表空间管理方式
SELECT tablespace_name, extent_management, allocation_type,segment_space_management FROM dba_tablespaces;
3.创建表空间，ASSM自动段空间管理,默认段空间管理manual
create tablespace tbs_zzkgwsgs datafile '+DATAC1' size 1024m autoextend on next 100m maxsize unlimited extent management local segment space management auto;
3.新建用户并指定表空间
create user zzkgwsgs identified by K2z6rhQTWp default tablespace tbs_zzkgwsgs;
4.授权用户
grant resource,connect to zzkgwsgs;