1.
select b.file_id "文件ID",
b.tablespace_name "表空间",
b.file_name "物理文件名"
from dba_free_space a,dba_data_files b
where a.file_id=b.file_id
group by b.tablespace_name,b.file_name,b.file_id,b.bytes
order by b.tablespace_name;
2.
create tablespace VMSINFODIFFUSION
datafile 'D:/app/Administrator/oradata/orcl/VMSINFODIFFUSION.dbf'
size 500M autoextend on next 5M maxsize 2000M;
3.
create user VMSINFODIFFUSION identified by VMSINFODIFFUSION default tablespace VMSINFODIFFUSION;
4.
grant resource,dba to VMSINFODIFFUSION;
