{12 高可用性その他}オンラインデータファイル移動

 

https://docs.oracle.com/cd/F19136_01/admin/managing-data-files-and-temp-files.html#GUID-E4CA8427-D8AE-45AC-A209-554D555758DE

sqlplus test/test@pdb11

select * from dba_data_files;

ALTER DATABASE MOVE DATAFILE '/oradata/orcl/pdb11/system01.dbf' 
  TO '/oradata/system01.dbf';

select * from dba_data_files;

ALTER DATABASE MOVE DATAFILE '/oradata/system01.dbf' 
  TO '/oradata/orcl/pdb11/system01.dbf';

select * from dba_data_files;