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:

Disable logging for tables only:

or

 

 

Leave a Reply

%d bloggers like this: