DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: expdp hangs on defining

  1. #1
    Join Date
    Sep 2015

    expdp hangs on defining


    i have a Oracle 11g I have mounted a NFS share an declare a dmpdir for my expdp.

    During my first expdp run, the nfs-server becomes unavailable for a time. I killed this job. Now, the mountpoints working fine, but the expdp makes some trouble.

    SQL> select * from dba_datapump_jobs;
    no rows selected
    There no jobs, for may datapump. If i do just a new connect as system user, the login still hangs:

    expdp system
    Export: Release - Production on Tue Sep 15 15:06:01 2015
    Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
    Connected to: Oracle Database 11g Release - 64bit Production

    The state of this job, hangs on defining. What is the problem here?

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    What is in the alert log? You might still have a session hanging around from the data
    pump export. You may need to restart your database. Hopefully you can log in as sys.

  3. #3
    Join Date
    Sep 2015
    yeah, that works for me!

    thank you!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width