1.oracle表空间相关操作

1.创建表空间

      create tablespace itms_space datafile 'C:\oracle\product\10.2.0\oradata\orcl\itms_space.dbf'size 100M autoextend on next 100M maxsize unlimited logging extent management local autoallocate segment space management auto;

1.1查看表空间存放位置：
select name from v$datafile;

2.删除表空间
     drop tablespace itsm_space including contents and datafiles;

3.创建临时表空间
CREATE TEMPORARY TABLESPACE temptspmdata
TEMPFILE 'D:\tablespace\tempspmdata.dbf'
SIZE 200m
AUTOEXTEND ON
NEXT 32m MAXSIZE 2048m
EXTENT MANAGEMENT LOCAL;

3.1设置缺省的临时表空间
alter database default temporary tablespace temptspmdata;

3.2为用户指定表空间
alter user arbor temporary tablespace temp;

4.查看表空间
select * from sys.dba_tablespaces;

5.查看用户和表空间
select username,default_tablespace from dba_users;