Database Administration (MOSC)

MOSC Banner

Error ORA-01276 thrown while trying to move datafile

edited May 15, 2018 3:37PM in Database Administration (MOSC) 15 commentsAnswered ✓

Hello experts,

                       I am trying to move datafile online but it is throwing below error.Kindly help me to resolve the issue.

SQL> alter database move datafile
'+DATADG/CDB12C/4FBDA940A623D744E0530B26760A9AF2/DATAFILE/sales.4642.944232199'
to '+DATADG/cdb12c/salespdb/sales.4642.944232199' reuse;

alter database move datafile
'+DATADG/CDB12C/4FBDA940A623D744E0530B26760A9AF2/DATAFILE/sales.4642.944232199'
to '+DATADG/cdb12c/salespdb/sales.4642.944232199' reuse

*

ERROR at line 1:

ORA-01276: Cannot add file +DATADG/cdb12c/salespdb/sales.4642.944232199.
File has an Oracle Managed Files file name.

Regards

Dhritiman Deb

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center