A new feature has been added in datapump of oracle 12c. We can import data with nologgin option i.e without generating logs. We sometimes face issue while importing big tables, as it generates lot of archive logs.

TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y – This parameter can be used to make the impdp nologging.

 

check the archive status before import

 

Import a table:

 

Check the archive status after import( No change observed)

 

Check the alert log

We can observe in the alert log that no archives has been generated as part of the import.

We can use nologging for specific object_types like TABLE or INDEX.