一个TABLESPACE对应多个数据文件

DROP  user EHRAUCHAN CASCADE; --注意 ：删除用户包括所有对象已经用户拥有的表中包括的数据。
select name from v$datafile;

DROP TABLESPACE "EHRAUCHANNEW" including contents and datafiles


create tablespace "EHRAUCHANNEW" datafile 
'H:\OracleDB\EHRAUCHAN.DBF' size 8096M,
'H:\OracleDB\EHRAUCHAN1.DBF' size 8096M,
'H:\OracleDB\EHRAUCHAN2.DBF' size 8096M,
'H:\OracleDB\EHRAUCHAN3.DBF' size 8096M,
'H:\OracleDB\EHRAUCHAN4.DBF' size 8096M,
'H:\OracleDB\EHRAUCHAN5.DBF' size 8096M,
'H:\OracleDB\EHRAUCHAN6.DBF' size 8096M,
'H:\OracleDB\EHRAUCHAN7.DBF' size 8096M,
'H:\OracleDB\EHRAUCHAN8.DBF' size 8096M,
'H:\OracleDB\EHRAUCHAN10.DBF' size 9096M,
'H:\OracleDB\EHRAUCHAN11.DBF' size 9096M, 
'H:\OracleDB\EHRAUCHAN12.DBF' size 9096M,
'H:\OracleDB\EHRAUCHAN13.DBF' size 4096M,
'H:\OracleDB\EHRAUCHAN14.DBF' size 4096M,
'H:\OracleDB\EHRAUCHAN15.DBF' size 9096M,
'H:\OracleDB\EHRAUCHAN16.DBF' size 9096M;

create user EHRAUCHAN  identified by EHRAUCHAN default tablespace EHRAUCHANNEW;
select * from dba_tablespaces
grant create session to EHRAUCHAN;
grant dba to EHRAUCHAN;
grant imp_full_database to EHRAUCHAN;