1. query
SQL>SELECT name FROM V$DATAFILE;
NAME
--------------------------------------------------------------------------------
+DGROUP1/edison/datafile/system.256.735732721
+DGROUP1/edison/datafile/undotbs1.258.735732723
+DGROUP1/edison/datafile/sysaux.257.735732721
+DGROUP1/edison/datafile/users.259.735732723
+DGROUP1/edison/datafile/example.269.735732895
+DGROUP1/edison/datafile/ioffice.271.735734741
6 rows selected.
2. create new tablespace
SQL>CREATE TABLESPACE ioffice datafile '+DGROPU1/edison/datafile/ioffice01' SIZE 10M
2>EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128k
3>SEGMENT SPACE MANAGEMENT AUTO;
SQL>SELECT name FROM V$DATAFILE;
NAME
--------------------------------------------------------------------------------
+DGROUP1/edison/datafile/system.256.735732721
+DGROUP1/edison/datafile/undotbs1.258.735732723
+DGROUP1/edison/datafile/sysaux.257.735732721
+DGROUP1/edison/datafile/users.259.735732723
+DGROUP1/edison/datafile/example.269.735732895
+DGROUP1/edison/datafile/ioffice.271.735734741
6 rows selected.
2. create new tablespace
SQL>CREATE TABLESPACE ioffice datafile '+DGROPU1/edison/datafile/ioffice01' SIZE 10M
2>EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128k
3>SEGMENT SPACE MANAGEMENT AUTO;