新建表空间:
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;