Which four actions are possible during an Online Data file Move operation?

Question

Options

• ACreating and dropping tables in the data file being moved
• BPerforming file shrink of the data file being moved
• CQuerying tables in the data file being moved
• DPerforming Block Media Recovery for a data block in the data file being moved
• EFlashing back the database
• FExecuting DML statements on objects stored in the data file being moved

• A
  74% (32)
• B
  9% (4)
• E
  16% (7)

Explanation

Block Media Recovery can be done while the data file was moved…and Media Recovery is not “The good news is that Oracle 12cR1 now offers the ability to move entire datafiles between different storage locations without ever having to take the datafiles offline. The datafiles being moved remain completely accessible to applications in almost all situations, including querying against or performing DML and DDL operations against existing objects, creating new objects, and even rebuilding indexes online. Online Move Datafile (OMD) also makes it possible to migrate a datafile between non-ASM and ASM storage (or vice-versa) while maintaining transparent application access to that datafile’s underlying database objects. OMD is completely compatible with online block media recovery, the automatic extension of a datafile, the modification of a tablespace between READ WRITE and READ ONLY mode, and it even permits backup operations to continue against any datafiles that are being moved via this feature.”

No community discussion yet for this question.