How to fix the Oracle error ORA-36630: (XSDUNION00) An empty base dimension list was specified in the concat dimension definition.?

In this post, you’ll learn more about the Oracle ErrorORA-36630: (XSDUNION00) An empty base dimension list was specified in the concat dimension definition. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36630: (XSDUNION00) An empty base dimension list was specified in the concat dimension definition.

Reason for the Error ORA-36630: (XSDUNION00) An empty base dimension list was specified in the concat dimension definition.

An empty concat dimension list was specified.

How to fix the Error ORA-36630: (XSDUNION00) An empty base dimension list was specified in the concat dimension definition. ?

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

Specify a valid list of dimensions when defining a concat dimension.