Oracle Error ORA-39040: Schema expression “string” must identify exactly one schema.

Oracle Error Message

ORA-39040: Schema expression “string” must identify exactly one schema.

Reason for the Error

For TABLE mode jobs, the SCHEMA_EXPR filter must identify exactly one schema.

Solution

Correct the the SCHEMA_EXPR filter specification.