We secure data from APEX application with following job command:
expdp admin/PWD@bsgdb001_high exclude=index,cluster,indextype,materialized_view,materialized_view_log,materialized_zonemap,db_link data_options=group_partition_table_data parallel=1 schemas=MADB_PROD dumpfile=%T_export_Prod_%u.dmp
And we get the following error:
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user ADMIN
ORA-06512: at "SYS.KUPV$FT", line 1142
ORA-06512: at "SYS.KUPV$FT", line 1744
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 1115
ORA-39244: failed to prepare queue table for Data Pump job.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 2197
ORA-04063: package body "SYS.DBMS_WORKLOAD_CAPTURE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_WORKLOAD_CAPTURE"
ORA-06512: at "SYS.DBMS_WRR_STATE", line 3
ORA-06512: at "SYS.DBMS_RANDOM", line 91
ORA-06512: at "SYS.DBMS_RANDOM", line 137
ORA-06512: at "SYS.KUPC$QUE_INT", line 2134
ORA-06512: at "SYS.KUPC$QUEUE_INT", line 493
ORA-06512: at "SYS.KUPV$FT_INT", line 983
ORA-06512: at "SYS.KUPV$FT", line 1646
ORA-06512: at "SYS.KUPV$FT", line 1103
According to our developer this is an error in the oracle apex database that is compromising our security. How can we resolve this issue?