Default: No timestamps are recorded
Purpose
Specifies that messages displayed during import operations be timestamped. You can use the timestamps to figure out the elapsed time between different phases of a Data Pump operation. Such information can be helpful in diagnosing performance problems and estimating the timing of future similar operations.
Syntax and Description
LOGTIME=[NONE | STATUS | LOGFILE | ALL]
The available options are defined as follows:
NONE
--No timestamps on status or log file messages (same as default)
STATUS
--Timestamps on status messages only
LOGFILE
--Timestamps on log file messages only
ALL
--Timestamps on both status and log file messages
Restrictions
None
Example
The following example records timestamps for all status and log file messages that are displayed during the import operation:
> impdp hr DIRECTORY=dpump_dir1 DUMPFILE=expdat.dmp SCHEMAS=hr LOGTIME=ALL TABLE_EXISTS_ACTION=REPLACE
For an example of what the LOGTIME
output looks like, see the Export LOGTIME parameter.