Hi guys,
one of developers added a datafile to a tablespace in OMF environment (12c DB) explicitly specifying the name. Obviously he got an error "ORA-01276 File has an Oracle Managed Files file name." but he didn't give up and decided to remove .dbf extension. In the end he succeeded in creating a file with this name '/opt/ora/db/CDB/2B7BF63F8D5196CBE053C124B183E26A/datafile/o1_mf_mboss_da_ccs54l6s_' , Now on 12c I'm trying to rename (move) it online, but get the same error:
alter database move datafile '/opt/ora/db/CDB/2B7BF63F8D5196CBE053C124B183E26A/datafile/o1_mf_mboss_da_ccs54l6s_' to '/opt/ora/db/CDB/2B7BF63F8D5196CBE053C124B183E26A/datafile/o1_mf_mboss_da_ccs54l6s_.dbf'
*
ERROR at line 1: ORA-01276: Cannot add file /opt/ora/db/CDB/2B7BF63F8D5196CBE053C124B183E26A/datafile/o1_mf_mboss_da_ccs54l6s_.dbf. File has an Oracle Managed Files file name.
How can I solve this issue? Don't wanna leave one "invalid named" datafile hanging around.