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

Thread: expdp hangs on defining

  1. #1
    Join Date
    Sep 2015
    Posts
    2

    expdp hangs on defining

    Hi,

    i have a Oracle 11g 11.2.0.4.0. 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.


    Code:
    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:

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

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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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
    Posts
    2
    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