Online MOVE mit Oracle 12c

Wie lange habe ich darauf gewartet – eine Ewigkeit – aber es ist toll:

SYS@TEST12E SQL>select file#,name from v$datafile;

     FILE# NAME
---------- ------------------------------
[...]
         9 /u01/oradata/TEST12E/datafile/o1_mf_users


9 rows selected.

SYS@TEST12E SQL>alter database move datafile 9;

Database altered.

SYS@TEST12E SQL>select file#,name from v$datafile;

     FILE# NAME
---------- ------------------------------
[...]
         9 /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/TEST12E/datafile/o1_mf_users_drjq4lx4_.dbf


9 rows selected.

Uppps . da stimmt was nicht - ist in dbs gelandet:

SYS@TEST12E SQL>show parameters db_create_file_dest

NAME                                 TYPE
------------------------------------ ---------------------------------
db_create_file_dest                  string


SYS@TEST12E SQL>alter system set db_create_file_dest='/u01/oradata' scope=both;

System altered.

SYS@TEST12E SQL>alter database move datafile 9;

Database altered.

SYS@TEST12E SQL>select file#,name from v$datafile where file#=9;

     FILE# NAME
---------- -------------------------------------------------------
         9 /u01/oradata/TEST12E/datafile/o1_mf_users_drjr07jl_.dbf