1、查询表空间位置
select * from dba_data_files;
-->d:\app\administrator\oradata\orcl\***.dbf
2、查看临时表空间位置
select * from v$tempfile
-->d:\app\administrator\oradata\orcl\***_tmp.dbf
3、创建临时表空间
create temporary tablespace icmamp_temp
tempfile 'd:\app\administrator\oradata\orcl\icmamp_temp.dbf'
size 100m
autoextend on
next 100m maxsize 20480m
extent management local;
4、创建表空间
create tablespace icmamp
logging
datafile 'd:\app\administrator\oradata\orcl\icmamp.dbf'
size 200m
autoextend on
next 200m maxsize 20480m
extent management local;
5、删除表空间
drop tablespace icmamp_temp including contents and datafiles cascade constraints;
6、创建用户并指定表空间
create user icmamp identified by 123456 default tablespace icmamp temporary tablespace icmamp_temp;
7、用户授权
grant connect,resource,dba to icmamp;