drop user oldoa cascade
create tablespace tbsoa DATAFILE 'F:\app\Administrator\oradata\orcl\tbsoa.dbf' size 1024m autoextend on next 30m;
create user oldoa identified by oldoa;
grant dba to oldoa;
alter user oldoa default tablespace tbsoa;
//--------------------------------------------------
create tablespace tbsmail DATAFILE 'F:\app\Administrator\oradata\orcl\tbsmial.dbf' size 1024m autoextend on next 30m;
create user sa identified by sa;
grant dba to sa;
alter user sa default tablespace tbsmail;
create tablespace sss datafile 'D:\app\Administrator\oradata\orcl\sss.dbf' size 50m autoextend on next 50m maxsize 20480m;
如果要删除该表空间,可加上including contents子句.
如: drop tablespace mytbs01 including contents ;
如果想在删除表空间的同时也删除掉对应的数据文件,那就在上面的语句最后加上 and datafiles
成为 drop tablespace mytbs01 including contents and datafiles;