Thursday, January 30, 2014

Oracle 12c nologging for impdp

There is very useful new feature in Oracle 12c impdp which you can use to get rid of logging when you are doing import.

For example big bulk imports you might want to take logging of (both table and index) this way archivelog disk is not getting full and you can save some time.  You can do this with impdp "TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y" option.

If you want you can also choose to remove only table or index logging:
only table data logging off during import:
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:TABLE
only index data logging off during import:
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:INDEX 

Default value for this parameter is TRANSFORM=DISABLE_ARCHIVE_LOGGING:N which is doing normal logging during import.

No comments:

Post a Comment