Which four actions are possible during an Online Datafile Move operation?
A.
Creating and dropping tables in the datafile being moved
B.
Performing file shrink of the data file being moved
C.
Querying tables in the datafile being moved
D.
Performing Block Media Recovery for a data block in the datafile being moved
E.
Flashing back the database
F.
Executing DML statements on objects stored in the datafile being moved
A&C&D&F
ACDF
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
ACDF