Oracle Error ORA-36985: (XSRELGID21) The source relation can be omitted only when using both surrogate GID and level order valueset.

Oracle Error Message

ORA-36985: (XSRELGID21) The source relation can be omitted only when using both surrogate GID and level order valueset.

Reason for the Error

Source relation was not specified.

Solution

Specify the source relation or both surrogate gid and level order valueset.