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

 

SQL> archive log list
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     232
Next log sequence to archive   234
Current log sequence	       234

Import a table:

[oracle@localhost ~]$ impdp dumpfile=dbaclass.dmp logfile=dbaclass.log directory=DUMP tables=test.TEST TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y

Import: Release 12.1.0.2.0 - Production on Sat Aug 22 03:40:41 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: sys/oracle@ORCL as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TABLE_01":  sys/********@ORCL AS SYSDBA dumpfile=dbaclass.dmp logfile=dbaclass.log directory=DUMP tables=test.TEST TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y 
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "TEST"."TEST"                               10.66 MB   93925 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "SYS"."SYS_IMPORT_TABLE_01" successfully completed at Sat Aug 22 03:41:23 2015 elapsed 0 00:00:30

 

Check the archive status after import( No change observed)

 

SQL> archive log list
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     232
Next log sequence to archive   234
Current log sequence	       234

Check the alert log

Sat Aug 22 03:36:06 2015
Resize operation completed for file# 10, old size 224000K, new size 226560K
Sat Aug 22 03:40:53 2015
DM00 started with pid=72, OS id=10034, job SYS.SYS_IMPORT_TABLE_01
Sat Aug 22 03:40:54 2015

DW00 started with pid=76, OS id=10036, wid=1, job SYS.SYS_IMPORT_TABLE_01

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.

TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:TABLE      

TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:INDEX