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: 363
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: 65152
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: SQL Loader Number Format
Next Topic: INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work
Goto Forum:
  


Current Time: Tue Aug 22 02:19:27 CDT 2017

Total time taken to generate the page: 0.04776 seconds