删除和创建表空间及用户-使用这些语句够用啦

DROP TABLESPACE cbtpro INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE cbtpro_index0 INCLUDING CONTENTS AND DATAFILES;
/

create tablespace cbtpro
datafile '/oradata/cbtpro/cbtpro.dbf'
size 512m
autoextend on
next 100m MAXSIZE UNLIMITED
extent management local;
/

create tablespace cbtpro_index0
datafile '/oradata/cbtpro/cbtpro_index0.dbf'
size 512m
autoextend on
next 100m MAXSIZE UNLIMITED
extent management local;
/

create user cbtpro
identified by cbtpro
default tablespace cbtpro
temporary tablespace TEMP
profile DEFAULT;