OracleDB12c New Feature: No Logging Option in Data Pump Import

Datapump Import impdp in 12c includes a new parameter to disable logging during data import. This option could improve performance of import tremendously during large data loads.

The TRANSFORM=DISABLE_ARCHIVE_LOGGING is used to disable logging. The value can be Y or N. Y to disable logging and N to enable logging. The second attribute specifies whether to exclude tables and/or indexes.

If the database is running with FORCE LOGGING enabled, data pump ignores disable logging request.

Examples:

Disable logging for tables and indexes:

impdp DIRECTORY=mydump DUMPFILE=hrtest.dmp \
  SCHEMAS=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y

Disable logging for tables only:

impdp DIRECTORY=mydump DUMPFILE=hrtest.dmp SCHEMAS=hr \
   TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:TABLE

impdp DIRECTORY=mydump DUMPFILE=hrtest.dmp SCHEMAS=hr \
    TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y \
    TRANSFORM=DISABLE_ARCHIVE_LOGGING:N:INDEX

Related