1、数据扩容
system登录pl/sql
alter tablespace APPS_TS_TX_DATA add datafile '/u01/PROD/data/a_txn_data11.dbf' size 5G autoextend ON ; alter tablespace APPS_TS_TX_DATA add datafile '/u01/PROD/data/a_txn_data06.dbf' size 5G maxsize 33554432000 autoextend ON ; alter tablespace APPS_TS_TX_DATA add datafile '/u01/PROD/data/a_txn_data07.dbf' size 5G maxsize 33554432000 autoextend ON ;
2、索引扩容
alter tablespace APPS_TS_TX_IDX add datafile '/u01/PROD/data/a_txn_ind08.dbf' size 5G maxsize 33554432000 autoextend ON alter tablespace APPS_TS_TX_IDX add datafile '/u01/PROD/data/a_txn_ind08.dbf' size 5G autoextend ON
文章评论