NOLOGGING Option (DISABLE_ARCHIVE_LOGGING)
The TRANSFORM parameter of impdp has been extended to include a DISABLE_ARCHIVE_LOGGING option.
The default setting of “N” has no affect on logging behaviour. Using a value “Y” reduces the logging associated with
tables and indexes during the import by setting their logging attribute to NOLOGGING before the
data is imported and resetting it to LOGGING once the operation is complete.
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
The effect can be limited to a specific type of object (TABLE or INDEX) by appending the object type.
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:TABLE
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:INDEX
Demo:-
[oracle@prod101:admin orcl101] expdp system/oracle schemas=scott directory=test_dir dumpfile=scott.dmp logfile=scott.log Export: Release 18.0.0.0.0 - Production on Fri Aug 24 04:00:35 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** schemas=scott directory=test_dir dumpfile=scott.dmp logfile=scott.log Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/VIEW/VIEW . . exported "SCOTT"."ORACLEDBWR" 17.29 KB 1792 rows . . exported "SCOTT"."ORACLEDBWR1" 17.29 KB 1792 rows . . exported "SCOTT"."TDE_TEST" 5.546 KB 1 rows . . exported "SCOTT"."EMP" 0 KB 0 rows ORA-39173: Encrypted data has been stored unencrypted in dump file set. Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: /u01/app/oracle/datapump/scott.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Aug 24 04:01:04 2018 elapsed 0 00:00:29
impdp system/oracle directory=test_dir dumpfile=scott.dmp logfile=impdp_scott.log remap_schema=scott:oradb transform=disable_archive_logging:y
Import: Release 18.0.0.0.0 - Production on Fri Aug 24 04:03:03 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** directory=test_dir dumpfile=scott.dmp logfile=impdp_scott.log remap_schema=scott:oradb transform=disable_archive_logging:y
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "ORADB"."ORACLEDBWR" 17.29 KB 1792 rows
. . imported "ORADB"."ORACLEDBWR1" 17.29 KB 1792 rows
. . imported "ORADB"."TDE_TEST" 5.546 KB 1 rows
. . imported "ORADB"."EMP" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at Fri Aug 24 04:03:43 2018 elapsed 0 00:00:39
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
