oracle 12c 移动数据文件

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

SQL> select file_name from dba_data_files;   FILE_NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/orcl/system01.dbf /u01/app/oracle/oradata/orcl/sysaux01.dbf /u01/app/oracle/oradata/orcl/undotbs01.dbf /u01/app/oracle/oradata/orcl/users01.dbf /u01/app/oracle/oradata/tt.dbf     SQL> create table tt (id int) tablespace tt;   Table created.     SQL> select * from tt;           ID ----------          1     SQL> alter database move datafile '/u01/app/oracle/oradata/tt.dbf' to '/u01/app/oracle/oradata/orcl/tt01.dbf';   Database altered.     SQL> select file_name from dba_data_files;   FILE_NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/orcl/system01.dbf /u01/app/oracle/oradata/orcl/sysaux01.dbf /u01/app/oracle/oradata/orcl/undotbs01.dbf /u01/app/oracle/oradata/orcl/users01.dbf /u01/app/oracle/oradata/orcl/tt01.dbf     SQL> select * from tt;           ID ----------          1