Examine the following query output:
You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?
A.
All database operations performed by the impdp command are logged.
B.
Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
C.
Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
D.
None of the operations against the master table used by Oracle Data Pump to coordinate its activities
are logged.
Explanation:
Oracle Data Pump disable redo logging when loading data into tables and when creating
indexes.
The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo
generation for the objects during the course of import. The Master Table is used to track the detailed
progress information of a Data Pump job.
The Master Table is created in the schema of the current user running the Pump Dump export or import,
and it keeps tracks of lots of detailed information.