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;