create_tspace.sql

##  DBA Command Post - create_tablespace.sql


create   tablespace &tspace
datafile '&file_spec' size &size_in_Mg M
default  storage ( initial     50K 
                   next        50K
                   minextents  1
                   maxextents  100
                   pctincrease 0 )
/
alter database backup controlfile to '&tspace._control.bkp' reuse
/