Which three actions are possible during an Online Data file Move operation?
A.
Performing Block Media Recovery for a data block in the data file being moved
B.
Flashing back the database
C.
Executing DML statements on objects stored in the data file being moved
D.
Querying tables in the data file being moved
E.
Creating and dropping tables in the data file being moved
F.
Performing file shrink of the data file being moved
CDE
A,C,D,E
An online data file move will fail for the following conditions:
Data file offline
“Flashback Database” operation is running
Concurrent media recovery is running
Data file resize is happening (only if it’s shrinking)
An online data file move will succeed for following conditions:
Block media recovery happening on the data file being moved
Tablespace containing the data file being moved is made read-only or read-write
Data file resize is happening (extending the size)
Online backup of data file is happening
A,C,D,E