How to fix the Oracle error ORA-36636: (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.?
In this post, you’ll learn more about the Oracle ErrorORA-36636: (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-36636: (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
Reason for the Error ORA-36636: (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
A non-unique concat dimension cannot be used as a base of a dependent unique concat.
How to fix the Error ORA-36636: (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension. ?
You can fix this error in Oracle by following the below steps
CHGDFN any dependent unique concat dimensions to NOT UNIQUE and retry.
Leave Your Comment