Adding new datafile

ALTER TABLESPACE APPS_TS_TX_DATA ADD DATAFILE '/QICAPPDB1/oracle/ERPPROD/db/apps_st/data/a_txn_data17.dbf' size 10240m

ALTER TABLESPACE APPS_TS_TX_IDX ADD DATAFILE '/QICAPPDB2/oracle/ERPPROD/db/apps_st/data/a_txn_ind19.dbf' size 10240m

Resizing the datafile

alter database datafile '/data1/oracle/ERPDEV/db/apps_st/data/a_txn_data07.dbf' resize 10240m

Alter database datafile '/QICAPPDB1/oracle/ERPPROD/db/apps_st/data/a_txn_data17.dbf' resize 20480m;

Addinf datafile(tempfile) to temp tablespace