Introduction: –  As Oracle user, we are learning Oracle export/import from 9i still changes are going on. 12c has introduced LOGTIME=ALL Parameter In Datapump. We are going to know about LOGTIME=ALL Parameter In Datapump in 12c. Data Pump Export is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be imported only by the Data Pump Import utility. The dump file set can be imported on the same system or it can be moved to another system and loaded there.

LOGTIME: Specifies that messages displayed during export operations be timestamped. It has been introduced in Oracle 12c.

Valid keyword values are ALL, [NONE], LOGFILE and STATUS.
EXAMPLE:

 

The date/time information can be used to see how long it takes for specific objects to be exported, useful for planning production runtimes.

Leave a Reply