asm管理的Oracle 创建用户表空间

查看数据库的存储是裸设备，ASM还是其他文件系统(根据目录)

select name from v$datafile;

raw  : /dev/raw/raw[n...]
asm : +dg/....
fs    : /oradata/.....

================================================================

--删除用户
drop user hse cascade;

--删除表空间
drop tablespace hse_data including contents;
drop tablespace hse_temp including contents;

--执行前先确定表空间文件路径是否正确
select file_name,tablespace_name from dba_data_files;

ALTER DISKGROUP DATA ADD DIRECTORY '+DATA/hse/datafile';

 

--创建临时表空间

create temporary tablespace hse_temp
tempfile '/+DATA/hse/datafile/hse_temp.dbf'
size 200m
autoextend on
next 100m maxsize unlimited
extent management local;

--创建表空间

create tablespace hse_data
datafile '/+DATA/hse/datafile/hse.dbf'
size 200m
autoextend on
next 100m maxsize unlimited
extent management local;

--创建用户

create user hse identified by hse
default tablespace hse_data
temporary tablespace hse_temp;

--赋权限
grant dba to hse;