There was a thread on this forum started with the same subject 3 years ago - that was locked back in April 2011, but I do not see what was the resolution, so I take the liberty to start it again.
We have a weekly backup procedure that does the following:
expdp <NAME>/<PASSW> directory=datapump schemas=<SCH1>,<SCH2> dumpfile=EXPDAT01.DMP logfile=EXPORT.LOG reuse_dumpfiles=YES
this used to work regularly until a month ago, when something happened to the DB, and since then we get the following message if we execute the above line:
Export: Release 11.1.0.6.0 - 64bit Production on Friday, 18 November, 2011
14:00:10
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 -
64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2862
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052
ORA-06512: at line 1
-------
interestingly if we use just "exp" and not "expdp" on the same DB it works.
i.e. this works:
exp <NAME>/<PASSWD> FILE=exp_database.dmp COMPRESS=N CONSISTENT=N CONSTRAINTS=N owner=<SCH1> GRANTS=N INDEXES=N RECORD=Y ROWS=Y LOG=exp_database.log
-----
We would like to understand why something that used to work stopped working and why exp works still when expdp does not?
Thanks.