Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASM move datafile in the same diskgroup

TK03Jul 11 2022

How can I move a datafile to different directory in the same ASM diskgroup ?
i.e

ALTER DATABASE MOVE DATAFILE '+DATA/BAKPSID/DATAFILE/test.902.1109774887' to '+DATA/test/datafile/test.902.1109774887';

*
ERROR at line 1:
ORA-01276: Cannot add file +DATA/test/datafile/test.902.1109774887. File has
an Oracle Managed Files file name.

SQL> show parameter db_create

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string +DATA

Comments
Post Details
Added on Jul 11 2022
2 comments
254 views