export ORACLE_SID=instance_name
sqlplus -S "/ as sysdba" <<SQL_EOF
CREATE TABLESPACE TBS_UNP_DATA DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_01.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_02.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_03.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_04.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_05.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_06.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_07.dbf' size 20G autoextend off;
exit
SQL_EOF
sqlplus -S "/ as sysdba" <<SQL_EOF
CREATE TABLESPACE TBS_UNP_DATA DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_01.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_02.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_03.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_04.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_05.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_06.dbf' size 30G autoextend off;
ALTER TABLESPACE TBS_UNP_DATA ADD DATAFILE '+CRMDGA/ngcrm/tbs_UNP_DATA_07.dbf' size 20G autoextend off;
exit
SQL_EOF