In this post, you’ll learn more about the Oracle ErrorXOQ-01759: A LOAD RETAIN command cannot be used in a default build specification or named build specification. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
XOQ-01759: A LOAD RETAIN command cannot be used in a default build specification or named build specification.
Reason for the Error XOQ-01759: A LOAD RETAIN command cannot be used in a default build specification or named build specification.
Cause: Either a named build specification or the default build specification for a dimension specified a load using RETAIN.
How to fix the Error XOQ-01759: A LOAD RETAIN command cannot be used in a default build specification or named build specification. ?
You can fix this error in Oracle by following the below steps
Action: Remove the RETAIN option from the default build specification or named build specification.