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

A.
Creating and dropping tables in the data file being moved

B.
Performing file shrink of the data file being moved

C.
Querying tables in the data file being moved

D.
Performing Block Media Recovery for a data block in the data file being moved

E.
Flashing back the database

F.
Executing DML statements on objects stored in the data file being moved

Explanation:

Incorrect:

Not B: The online move data file operation may get aborted if the standby recovery process takes
the data file offline, shrinks the file (not B), or drops the tablespace.
Not D: The online move data file operation cannot be executed on physical standby while standby
recovery is running in a mounted but not open instance.
Note:
You can move the location of an online data file from one physical file to another physical file while
the database is actively accessing the file. To do so, you use the SQL statement ALTER
DATABASE MOVE DATAFILE.
An operation performed with the ALTER DATABASE MOVE DATAFILE statement increases the
availability of the database because it does not require that the database be shut down to move
the location of an online data file. In releases prior to Oracle Database 12c Release 1 (12.1), you
could only move the location of an online data file if the database was down or not open, or by first
taking the file offline.
You can perform an online move data file operation independently on the primary and on the
standby (either physical or logical). The standby is not affected when a data file is moved on the
primary, and vice versa.
Reference: Oracle Data Guard Concepts and Administration 12c, Moving the Location of Online
Data Files

Show Hint

← Previous question

Next question →

dmx

The Oracle Database 12c Online Move data file feature provides the capability to move an
online data file from one kind of storage system to another while the database is open and
accessing the file.
This implies that queries, DML and DDL operations can be performed while the data file is
being moved:
• You can create tables and indexes.
• You can rebuild indexes online.
• You can select tables and partitions data.
• If objects are compressed while the data file is moved, the compression remains the
same.
This means that many maintenance operations can be used to move:
• Data files from one kind of storage system to another
• A database into ASM without going down
ADO can benefit from this new enhancement. It allows easy, transparent ADO actions, such as
data movement to other storage tier while tablespaces or data files move to another storage
tier. Associated segments consequently can move to another storage tier.

Compatibilities
NOT compatible with:
• Data file OFFLINE
• Concurrent FLASHBACK
DATABASE operation
• Concurrent media recovery
• data file RESIZE (shrink) operation
Compatible with:
• Block media recovery
• Tablespace made READ ONLY or
READ WRITE
• data file RESIZE (extension)
• Online backup

An Online Move data file operation is not compatible when:
• The data file is an OFFLINE data file
• A concurrent flashback database operation is executing
• A media recovery is completing
• A file shrink operation or tablespace offline/drop operation involving the same file is
performing
But it is compatible with:
• Block media recovery
• ALTER TABLESPACE READ ONLY or READ WRITE operations
• Data file extension operation
• Tablespace/database online backup mode involving the same file

взято из Oracle Database 12c Student Guide vol-1