move datafile

[big]

Hi,

On 19.9 C on AIX

I want to run:

SQL> ALTER SESSION SET container=pdb2;

SQL> ALTER DATABASE MOVE DATAFILE '/u01/app/oracle/oradata/pdb2/system01.dbf' TO '/u02/app/oracle/oradata/pdb2/system01.dbf' REUSE;

Should I copy the data file before to new location using OS cp commande?

Or oracle will do it?

Thanks.

[ErmanArslansOracleBlog]

The REUSE keyword indicates the new file should be created even if it already exists. That is REUSE overwrites data file with the same name. So I guess this answers your question.

[big]

Thank you.

Should copy them to new location or not?

Regards.

[ErmanArslansOracleBlog]

No, you don't need to copy or move.
& you are relocating a data File and overwriting an existing File.

Also see -> 12C New Feature : Move a Datafile Online (Doc ID 1566797.1)