Datafile management
++++++++++++++++++++++++++++++++++++++++++++++========
Add 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
++++++++++++++++++++++++++++++++++++++++++++++========
Resize datafile:
++++++++++++++++++++++++++++++++++++++++++++++========
ALTER TABLESPACE XXSIP '/data2/oracle/OICDEV/db/apps_st/data/XXSIP04.dbf' resize 30720m
alter database datafile '/data1/oracle/OICDEV/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;
Alter database datafile '/QICAPPDB1/oracle/ERPPROD/db/apps_st/data/undo03.dbf' resize 10240m
Alter database datafile '/QICAPPDB1/oracle/ERPPROD/db/apps_st/data/undo01.dbf' resize 5120m