Recently I am upgrading from Oracle 11g to 18c.
So everything was working fine in 11g but in 18c I am getting an error
ORA 31626: job does not exist
So the work flow is I have a scheduler job named CREATE_BACKUP which runs every week. It contains all the code to create the backup
To create DB backup we use DBMS_DataPump API and initially doing
DBMS_DataPump.OPEN(operation => 'EXPORT', job_mode => 'SCHEMA', remote_link => NULL, job_name => 'J$AIM_BACKUP', VERSION => 'LATEST');
Once again everything is working fine in Oracle 11g but when I run in 18c I am getting an error
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 1137
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5285
ORA-06512: at line 14
- ORA-31626: job does not exist
I am already granting EXP_FULL_DATABASE and DATAPUMP_EXP_FULL_DATABASE to the corresponding user while database installation.
Do you think, there might be something I can check what's the specific reason for the error? Or anything I missed or any suggestions?