常用OracleSQL

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;