创建表空间和用户

-- 查询表空间位置

select * from dba_data_files;

-- 创建表空间

create tablespace DBMTest1
logging
datafile 'D:\APP\AIRUCHEN\ORADATA\ORCL\DBMTest1.dbf'
size 512m autoextend
on next 50m maxsize unlimited extent management local
segment space management auto;

-- 创建用户 DBMTest1，指定表空间
create user DBMTest1

default tablespace DBMTest1

-- 设置用户密码 为DBMTest1

identified by DBMTest1;

-- 赋权限

grant dba to DBMTest1;