Home » RDBMS Server » Server Utilities » query to check data pump (
query to check data pump [message #521140] Fri, 26 August 2011 10:01 Go to next message
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
Can we query on database to check if data pump was run on
scheduled time incase we dont have access to operating system to
see the log file.

Re: query to check data pump [message #521143 is a reply to message #521140] Fri, 26 August 2011 10:12 Go to previous message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select table_name, comments from dict where lower(comments) like '%pump%';

If answer is not there, then you have to include it in the job/shell/... that sxchedules the data pump.

Previous Topic: datapump imp full with network_link
Next Topic: Problems Loading Data Into Table - SQL Loader
Goto Forum:

Current Time: Tue May 21 08:09:49 CDT 2024