--case 1 add14:25:04 FPYJ(150_9)@test> alter tablespace fpyj_data02 add datafile '/oradata02/test/test/fpuj_data011.dbf' size 10m autoextend on;Tablespace altered.--case 2 rename14:26:51 SYS(150_11)@test> alter tablespace fpyj_data02 offline;Tablespace altered.[oracle@Oracle11g test]$ pwd/oradata02/test/test[oracle@Oracle11g test]$ cp fpuj_data011.dbf fpuj_data0111.dbf14:28:28 SYS(150_11)@test> alter tablespace fpyj_data02 rename datafile '/oradata02/test/test/fpuj_data011.dbf' to '/oradata02/test/test/fpuj_data0111.dbf';Tablespace altered.Elapsed: 00:00:00.0414:29:23 SYS(150_11)@test> alter tablespace fpyj_data02 online;Tablespace altered.--case 3 drop14:29:47 SYS(150_11)@test> alter tablespace fpyj_data02 drop datafile '/oradata02/test/test/fpuj_data0111.dbf';Tablespace altered.
转载于:https://www.cnblogs.com/iyoume2008/p/7069867.html
相关资源：JAVA上百实例源码以及开源项目