新建表空间：

create temporary tablespace GDZC_TEMP
tempfile 'E:\app\Administrator\oradata\orcl\GDZC_TEMP01.DBF' 
size 10240m  
autoextend on  
next 50m maxsize 20480m  
extent management local; 

create tablespace GDZC_DATA
logging  
datafile 'E:\app\Administrator\oradata\orcl\GDZC_DATA01.DBF' 
size 20480m  
autoextend on  
next 50m maxsize 20480m  
extent management local;

DROP TABLESPACE GDZC_DATA INCLUDING CONTENTS AND DATAFILES;