ORA-33003 (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.

Translate this page

Oracle Database Error ORA-33003

ORA-33003 (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.

Cause

The user tried to specify a dimension in a dataflow-related clause in an aggmap which is already in another RELATION statement, DIMENSION statement, or possibly dimensioning the AGGMAP, or they specified a composite or conjoint dimension, or an object which is not a dimension

Action

Remove the conflicting reference or specify a valid object

User Posts for ORA-33003

Jun162017

showbox forShowbox App gives you unlimited access to watch latest movies, tv shows on your mobile.

Post your own questions, answers and tips for ORA-33003

No registration required

CAPTCHA Image New word