OraFAQ Forum: Server Utilities » query to check data pump

Home » RDBMS Server » Server Utilities » query to check data pump (10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

query to check data pump [message #521140]

Fri, 26 August 2011 10:01

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

Report message to a moderator

Re: query to check data pump [message #521143 is a reply to message #521140]

Fri, 26 August 2011 10:12

Michel Cadot
Messages: 68454
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 04 18:45:30 CDT 2023