创建表空间
- 先查询其它表空间路径及文件,复制FILE_NAME字段对应的路径
select * from dba_data_files;
- 创建表空间DEMOBPM,文件名改成DEMOBPM.DBF
create tablespace DEMOBPM datafile 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\DEMOBPM.DBF' size 500m autoextend on next 100m maxsize unlimited;
- 创建用户demobpm ,设置表空间DEMOBPM,identified by后为密码
create user demobpm identified by demobpm default tablespace DEMOBPM temporary tablespace temp profile default;
- 添加权限所有权限,根据情况自行选择
grant create session, connect, resource to demobpm;
grant all privileges to demobpm
找了好多资料,然后测试出来的结果,欢迎留言或指正其它问题。