Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DataPump Log Files

2906802Feb 17 2017 — edited Feb 17 2017

Hi All,

When I create Export Job (via DataPumpExport Wizard) it run succesfully,

whenever i click on one of the folders “Exportjobs” a list of existing datapump jobs is shown. and below a small tab titled “log files”. This tab loggs the following error:

CHECKING MASTER TABLE

PL/SQL procedure successfully completed.

Commit

Error starting at line : 35 in command -

BEGIN

  IF (:UTL_ERROR IS NOT NULL) THEN

    Raise_application_error(-20001,:UTL_ERROR);

  END IF;

END;

Error report -

ORA-20001: STATE IS NOT 'NOT RUNNING'

ORA-06512: on  line 3

I’m using sqldev version  4.1.5.21with db version 11gR2

Thanks,

Andrey Antipov

Comments

Frank Kulash

Hi, @user-e2y4b
This question was posted in the English-language space. There's a separate space for Spanish language:
Base de Datos Discusión General — oracle-tech
I'll try to move the thread there for you.

mathguy

Please note that this forum es solo en ingles. Either you state your question and accept answers in English, or look for a Spanish language forum (knowing that participation will be much more limited).
As to the error: Tables like AH135D are understood within the subquery (the join), but not outside it. The UPDATE statement only sees the result of the subquery, with its columns.
Either move the WHERE clause INSIDE the query, or give the subquery and its columns aliases and use those in the WHERE clause. (You may leave out the subquery alias - and perhaps even the column aliases, if there is no risk of confusion - but in a problem like this it is a best practice to alias the subquery and also the columns within it.)

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 17 2017
Added on Feb 17 2017
0 comments
322 views