Oracle deletes dba_datapump_jobs records

We sometimes encounter errors when exporting data using expdp. In this way, some records are generated in dba_datapump_jobs. You can see the following command:

Select * From dba_datapump_jobs;

Now we can see the corresponding job_name. Follow these steps to clear it:

1. Copy job_name, for example, schemas_scott2, and then execute:

Drop table schemas_scott2;

2. Execute again

Select * From dba_datapump_jobs;

Now the name of job_name has changed. In this example, the name is changed to bin $ czhed4gttr2qb9bbx8esaw = $0.

Execute the following SQL statement:

Purge table "bin $ czhed4gttr2qb9bbx8esaw = $0 ";

 

This is done.