Search results

How To Import Data With Nologgin Option In Oracle 12c

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.


No comments:

Post a Comment