Skip to main content

12 Posts on 12c: Transform to Disable Logging

Archive logging during import operations can be disabled. By disabling archive logging, we accept the trade-off of recovery with reduced resource contention on the database during data loads and index rebuilds on import.  Disabling archive logging is especially handy for those DBA performing table or schema refreshes on a regular basis in non-production environments where recovery is less of a concern.

Disabling archive logs can be performed on import operations invoked by command-line and parameter file. To disable archive logs on import, specify the following parameter: 

TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y

The screenshot below shows how this may be using during an import and remap to new schema.


DBMS_DATAPUMP allows for additional granularity by accepting options to disable archive logs at the index or table level specifically. 




NOTE: This parameter is ignored for create table  and index operations if the database or tablespace is in FORCE LOGGING mode. 

Source

Comments