In-flight Masking for Oracle 18c Database throws error during the Data Pump Import
Article ID: 262870
Updated On:
Products
Issue/Introduction
We have configured in-flight masking and doing export/import from GT subset.
While running the export, the .dmp files are getting created, but import is not working.
We are seeing the following in the log:
Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
ORA-31634: job already exists
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 1138
ORA-31637: cannot create job ~CUSTOMERS for user DESTINATION
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1131
Environment
Release : 4.10
Resolution
We should try addressing the first error first; Ora-31634: job already exists.
To resolve the ORA-31634 error, you can try the following steps:
- Check if the job already exists by querying the DBA_DATAPUMP_JOBS view.
- If the job does exist, you can either remove it using the DROP_JOB command or modify the existing job using the ALTER_JOB command.
- If the job does not exist, try specifying a different name for the job when creating or starting it.
If you still have issues, work with your Oracle DBA to help determine the cause.
The issue could be related to a Grant issue, and not having the required permissions to create the job, or the aq_tm_processes is greater than zero, and the streams_pool_size is greater than zero, as the data pump uses these to work.
See https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9532917900346934390
Feedback
