LOGTIME:
Logtime=Status parameter specifies that you want to have messages displayed with timestamps during export Or import.
[oracle@prod101:dpdump source] expdp system/manager directory=DATA_PUMP_DIR dumpfile=sample.dmp logfile=sample.log schemas=sample LOGTIME=STATUS Export: Release 18.0.0.0.0 - Production on Fri Aug 17 14:32:58 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 17-AUG-18 14:33:00.244: Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=DATA_PUMP_DIR dumpfile=sample.dmp logfile=sample.log schemas=sample LOGTIME=STATUS 17-AUG-18 14:33:03.924: Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA 17-AUG-18 14:33:04.478: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS 17-AUG-18 14:33:09.326: Processing object type SCHEMA_EXPORT/STATISTICS/MARKER 17-AUG-18 14:33:09.515: Processing object type SCHEMA_EXPORT/USER 17-AUG-18 14:33:09.623: Processing object type SCHEMA_EXPORT/ROLE_GRANT 17-AUG-18 14:33:09.680: Processing object type SCHEMA_EXPORT/DEFAULT_ROLE 17-AUG-18 14:33:09.783: Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA 17-AUG-18 14:33:10.000: Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA 17-AUG-18 14:33:16.778: Processing object type SCHEMA_EXPORT/TABLE/TABLE 17-AUG-18 14:34:46.817: . . exported "SAMPLE"."DEMO" 20.71 KB 38 rows 17-AUG-18 14:34:46.865: . . exported "SAMPLE"."DEMO1" 872.4 KB 99901 rows 17-AUG-18 14:34:46.991: . . exported "SAMPLE"."DEMO2" 8.568 MB 999901 rows 17-AUG-18 14:34:48.463: Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded 17-AUG-18 14:34:48.496: ****************************************************************************** 17-AUG-18 14:34:48.499: Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: 17-AUG-18 14:34:48.503: /u01/app/oracle/admin/source/dpdump/sample.dmp 17-AUG-18 14:34:48.532: Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Fri Aug 17 14:34:48 2018 elapsed 0 00:01:50
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