create tablespace fgh_cs4 datafile ‘G:\DB\ORACLE\Oracle_Space\fgh\fgh_cs4.dbf‘ size 100M; --创建表空间
create user fgh_cs4 identified by fgh_cs4 default tablespace fgh_cs4; --创建用户并绑定表空间
grant connect,resource to fgh_cs4; --赋予权限
grant dba to fgh_cs4; --赋予权限
drop user fgh_cs4 cascade;--删除用户(需要有表权限)
drop tablespace fgh_cs4 including contents and datafiles; --删除非空表空间，包含物理文件