4 Replies Latest reply: Feb 15, 2014 1:30 PM by User781951-Oracle RSS

    whether job running or not

    user11221081

      Hello Guys

       

      I am running an import which is really urgent.now i am not getting whether it is running or stucked

       

      on checking in dba_datapump_jobs status

       

      SQL> select job_name,state from dba_datapump_jobs;

       

       

      JOB_NAME                       STATE

      ------------------------------ ------------------------------

      SYS_IMPORT_FULL_01             EXECUTING

       

      please clear me whether it is running or not..how do i make sure that it is running

       

      also in log it is showing below from more than 40 mins

       

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX

       

      please clear me its urgent