查看已经创建的表空间
select * from dba_data_files;
创建表空间
一般是创建一个主题表空间,对应一个索引表空间
CREATE SMALLFILE TABLESPACE TS_IDX_SETTLEMAG
DATAFILE '/u01/app/oracle/oradata/IRIDB/C1F471CBE7B80559E0537800A8C0EB2A/datafile/TS_IDX_SETTLEMAG.dbf' SIZE 8g
REUSE LOGGING
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
删除表空间及下面的文件(即删除非空表空间):
drop tablespace DEMOSPACE including contents and datafile
查找用户
select * from dba_users;