1、查询表空间路径
select name from v$tempfile;
建完以后可以用以下语句查看是否成功
select tablespace_name,file_name from dba_data_files
2、新建表空间
create tablespace xxx
logging
datafile '表空间路径/xxx.dbf'
size 500m //分配的表空间大小
autoextend on
next 32m maxsize unlimited
extent management local;
3、新建用户,密码并分配权限
create user xxx identified by xxx
alter user xxx default tablespace xxx
grant create any table to xxx
grant CREATE ANY DIRECTORY,create session,create table,create view,unlimited tablespace to xxx
grant create any procedure to xxx
grant execute any procedure to xxx
grant DEBUG CONNECT SESSION to xxx
grant DEBUG ANY PROCEDURE to xxx