If you use the %U or %L wildcard character in the file name component of a Uniform Resource Identifier (URI) during a Data Pump load, you receive the following errors:

ORA-31640: unable to open dump file

ORA-17503: ksfdopn:11 Failed to open file

ORA-17500: ODM err:ODM HTTP Bad Request 

Workaround:

Do not use wildcards. Instead, list every file name as part of the DUMPFILE parameter.

In releases prior to Oracle Database 19c, the Oracle Data Pump always enabled secure roles that were granted to the user running the data pump. Starting in Oracle Database 19c, the data pump no longer enables these roles by default. There is a new parameter, ENABLE_SECURE_ROLES, to control whether those roles should be enabled for the data pump job.

Workaround:

None.