1 --创建临时表空间  2 create temporary tablespace data_temp  3 tempfile 'D:\oracle\oraudata\data_temp.dbf'  4 size 2000m  5 autoextend on  6 next 500m  7 extent management local;  8  9 --创建数据包空间 10 create tablespace data_data 11 logging 12 datafile 'D:\oracle\oraudata\data_data.dbf' 13 size 2000m 14 autoextend on 15 next 500m 16 extent management local; 17 18 19 --创建用户并指定表空间 20 21 create user dbadmin identified by dbpass 22 default tablespace data_data 23 temporary tablespace data_temp; 24 25 --删除用户命令 26 --drop user dbadmin cascade 27 28 --给用户授予权限 29 grant connect,resource to dbadmin 30 31 --撤权 32 --revoke connect,resource from dbadmin

1 --删除表空间2 --可以先将其offline3 alter tablespace zeus_data offline;4 --将磁盘上的数据文件一同删除5 drop tablespace zeus_data including contents and datafiles;