How to fix the Oracle error ORA-36999: (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specified when creating any non-surrogate grouping id.?

In this post, you’ll learn more about the Oracle ErrorORA-36999: (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specified when creating any non-surrogate grouping id. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36999: (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specified when creating any non-surrogate grouping id.

Reason for the Error ORA-36999: (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specified when creating any non-surrogate grouping id.

use variable/relation gid without providing the source relation

How to fix the Error ORA-36999: (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specified when creating any non-surrogate grouping id. ?

You can fix this error in Oracle by following the below steps

use the surrogate or provide the source relation