Renaming/Relocating/Move Data Files ONLINE from Release 12.1
Note: Online move only works with Enterprise Edition(EE). When we try to perform online move in SE it will fail with below error. SYS@EPMDEV > ALTER DATABASE MOVE DATAFILE '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev' TO '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev.dbf'; ALTER DATABASE MOVE DATAFILE '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev' TO '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev.dbf' * ERROR at line 1: ORA-00439: feature not enabled: online move datafile SYS@EPMDEV > !oerr ora 439 00439, 00000, "feature not enabled: %s" // *Cause: The specified feature is not enabled. // *Action: Do not attempt to use this feature. In SE we have to perform datafile rename in same old traditional way (OFFLINE).. Renaming an Online Data File: SYS@EPMDEV > ALTER DATABASE MOVE DATAFILE '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev' TO '/u05/odb/ORADATA_2/EPMDEV/epm_hfm_dev_1.dbf'; Relocating an...