Cleaning up abnormal stopped (orphaned) datapumb jobs

Posted by Blogger on August 17, 2010

Reason : Some time data pumb jobs marked as orphaned (stopped abnormally) and job information still remain in database. On starting datapump job start, job name table automatically created in database for keeping job related information. All data export and import operation will aborted.Solution :... [read more]

Rating

not rated
Login to rate this.

Reviews

Submit a comment / review

There are currently no comments or reviews.

Related

  • In one of my current projects I have some pivot reports that show count of issues in different states. Grouping depends on report. States are dynamic ...
    By Gunnar Peipman on January 2, 2012
  • A while back, I showed how you could use the query syntax and Rx to code a drag-drop operation similar to the way you might describe  the process to ...
    By Thinq LINQ on August 27, 2011
  • Hi All, Ari Ijäs shared a nice post includes a simple steps to configure Search Services Application in SharePoint Server 2010 to crawling for anony...
    By Mohamed Abdel Ghaffar on April 16, 2011
  • How to set SharePoint blog comments permission If you want to allow your SharePoint blog visitors to comment on blog posts you need to explicitly...
    By zakir hossain on March 31, 2011
  • This sample show how to read data from excel file by using Microsoft.Jet.OLEDB.More information about excel connectionstring see http://www.connection...
    By TOM on December 13, 2011
  • though logically the same, this is easier to read: select coalesce( (select CURRENT_TIMESTAMP > unlocked_expiration from i...
    By Michael Buen on April 24, 2008
  • One of the new feature in SSMA for MySQL v.5.1 is the support for converting MySQL LIMIT clause to SQL Server “Denali” OFFSET/FETCH NEXT clause. L...
    By wellyslee (SSMA Team's Blog) on July 13, 2011
  • Formula:Memory Consumed = (Number of Oracle Processes + 1) X (Size of Patched)Example:memory consumed = [ (select value from v$parameter where name='p...
    By javeedkaleem on January 13, 2012

Submit a review:

Login required.