Oracle Error ORA-30390: the source statement is not equivalent to the destination statement

Oracle Error Message

ORA-30390: the source statement is not equivalent to the destination statement

Reason for the Error

the set of rows returned by the source SQL text is not the same as the set of rows returned by the destination SQL text

Solution

Make sure both source and destination statement return the same number of rows