move datafile

Posted by big on Mar 22, 2023; 6:08pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/move-datafile-tp11733.html

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.