Home » RDBMS Server » Server Utilities » query to check data pump (10.2.0.4)
query to check data pump [message #521140] Fri, 26 August 2011 10:01 Go to next message
varunvir
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.

Thanks,
Varun
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: 68625
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.

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


Current Time: Thu Mar 28 11:38:51 CDT 2024