In this post, you’ll learn more about the Oracle ErrorORA-36985: (XSRELGID21) The source relation can be omitted only when using both surrogate GID and level order valueset. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-36985: (XSRELGID21) The source relation can be omitted only when using both surrogate GID and level order valueset.
Reason for the Error ORA-36985: (XSRELGID21) The source relation can be omitted only when using both surrogate GID and level order valueset.
Source relation was not specified.
How to fix the Error ORA-36985: (XSRELGID21) The source relation can be omitted only when using both surrogate GID and level order valueset. ?
You can fix this error in Oracle by following the below steps
Specify the source relation or both surrogate gid and level order valueset.