12 Posts on 12c: DataPump LOGTIME parameter

With the introduction of the LOGTIME parameter, DataPump operations will now report report timestamps from the system.


LOGTIME parameter accepts four different values:

  • NONE : (default) No timestamp information reported; classic 11g behavior.
  • STATUS : Timestamp information only reported to STDOUT
  • LOGFILE : Timestamp information only reported to specified log file. 
  • ALL : Timestamp information reported to both STDOUT and log file. 


Timestamp information can be included in DataPump operations using the DBMS_DATAPUMP package as well. The SET_PARMETER procedure can set the value of the LOGTIME  parameter with the following syntax:



Editor note: When I started this series, twitter friendly URL titles weren't part of the consideration. This is the same series, but better titles. Thanks

Comments

Post a Comment

Popular posts from this blog

Tariffs are bad for you.

Headlines from today state that the new Trump administration will put a 25% tariff on imports from Mexico, and Canada. Additionally, a 10% tariff on goods imported from China.  A tariff is a fee charged by the Federal government on goods coming into the country. That fee is paid by the importer, not the exporter.  For example, Target wants to sell PlayStation in their stores, so they purchase them from Sony, who builds these in China. Target receives the shipment of PlayStations, where they will be charged the tariff. Target pays the tariff to the Government to receive these goods.  Target then must decide how to recoup the additional fees. They can either choose to eat the cost and reduce their revenue, or they can increase the selling cost. The outcome is a combination of the two.  As a result, consumer prices, specifically for food and cars are going to go up. And businesses lose money by having to pay tariffs and selling few items.   For th...
Read more

AWS Re:Invent 2024

 I have the privilege of attending AWS Re:Invent conference from 02-Dec to 06-Dec. Here's my planned schedule for the week.  Sunday, 01-Dec Depart MSP @ 6:45pm CST Arrive LAS @ 8:12pm PST Monday, 02-Dec Design Secure and resilient relational database architectures on AWS Observability-driven development AWS Fundamentals for the accidental SQL Server database administrator Unleashing AWS Agility with Terraform How to navigate your SQL Server Migration journey with AWS Deep Dive into Amazon DynamoDB using Design Puzzles Visionaries in the Stadium w/ Angela Duckworth and some AI folks Tuesday, 03-Dec Identify and manage Amazon Aurora & RDS Snapshots Scalable database solutions with Aurora PostgreSQL Limitless Database Data models for Amazon Neptune using GenAI and diagram-as-code tools Deep Dive into Amazon Aurora query plan management Bingo Night Hashicorp Customer Reception @ Chica Wednesday, 04-Dec AWS Re:Invent 5k Race Essentials for migrating from Oracle to Amazon Aurora...
Read more